Search results for query: *

or that :)

The trick is to join the table to itself. Let's assume that your table is named Item and has the following column names: Desc, PK, FK Your SQL would look something like this: SELECT Item.Desc, Item_1.Desc, Item_2.Desc FROM (Item LEFT JOIN Item AS Item_1 ON Item.PK = Item_1.FK) LEFT JOIN...

The only way I know of - from a database perspective - is to use the like operator (select * from table where text_field like '%variable%') Don't expect performance to be great. I would start with like and go from there. There must be utilities to parse out & index key words. Anybody know of...

Unless I'm missing something check constraints are used for data storage (add/update), not retrieval. The bigger question is, why were the tables "partitioned" to begin with? Doing so defeats the purpose of a database system. My guess is that the performance hit for union'ing 100...

How about a .bat/.vbs script to execute each of the .sql files via isql?

Do you have server-side scripts? One approach... When building the form, store the primary key for each row in a hidden input field. When the form is submitted issue separate deletes for each of the rows i.e. if the check box is on build the delete statement dynamically using the value of the...

It's a good idea to keep administration stuff inside the database so TSQL is probably the way to go. Try using a cursor to spin through the result set & dump.

Great, glad things worked out.

Hi yoshi88, The "controls" on your form (buttons, labels...) should have a visible property. Add code to the form's load event to check the admin id and set the appropriate visible properties to false. Hope this helps

Following is a complete trigger that I use. It probably has more than you are looking for but it does the type of thing that you are trying to do. if exists (select * from sysobjects where id = object_id('dbo.proc_stat_update') and sysstat & 0xf = 8) drop trigger dbo.proc_stat_update GO...

Variation: select * from beverage_sales where time_of_sale = (select min(time_of_sale) from beverage_sales) or time_of_sale = (select max(time_of_sale) from beverage_sales)

In Access you can define a relationship between the two tables and enable cascading updates. The same functionality could then be coded in SQL Server as a trigger. However, this is a no-no from a design perspective. The customer table should have a primary key that NEVER changes. Use an...

Triggers have access to two virtual tables called “inserted” and “deleted”. Use select statements to get at the columns & build string for emailing. Keep in mind that an update is a delete and an add. So old values can be retrieved from deleted and new values from inserted. Following is a...

I have a similar situation. What I do is use a “status” table to keep track of what is running & Utilize two SP’s. For example: Sched SP_A to run every two minutes SP_A checks the status table to see if SP_B is running. If not, run SP_B SP_B starts by turning indicator on in the status...

You can use IDCAMS, SYNCOSRT would also work. SYNCSORT is good if you need to select records, summarise, sort, etc. Following is a IDCAMS example:<br> <br> //STEP1 EXEC PGM=IDCAMS <br> //SYSPRINT DD SYSOUT=*<br> //DD1 DD DSN=FILEIN1,DISP=SHR<br> // DD DSN=FILEIN2,DISP=SHR...

Thanks,<br> <br> I'll give it a shot!

FYI - I figured out how to do it.<br> <br> html tag:<br> <br> &lt;IMG SRC=&quot;get_image.cgi&quot;&gt;<br> <br> CGI:<br> <br> #!/usr/bin/perl<br> print &quot;Content-type:image/jpeg\n\n&quot;; <br> ...<br> binmode STDOUT;<br> print $image; <br> <br> <br> where $image is the binary image.<br>...

My isp has a counter utility that is called from the image tag as follows:<br> <br> &lt;img SRC=&quot;/cgi-bin/Count.cgi?name=pack86&font=E&quot; align=BOTTOM&gt;<br> <br> I want to be able to do the same type of thing. That is, have a CGI that returns a jpeg file.<br> <br> Any ideas?<br> <br>...

Sounds like a solution! Hope it works out for you.<br> <br> I have a question. From what I know - and I'm still learning - there are two ways of getting POST data. One is via:<br> <br> read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});<br> <br> You then need to parse out the variables from...

Not sure if this will help but...<br> <br> Your GUI options are limited because CICS is a text based interface. However, pop up windows / drop down boxes can be simulated. Software AG's Natural (4GL) supports this nicely. Natural runs under CICS so I assume you could code your own drop downs...