Search results for query: *

I'm trying to use an After Update trigger to compare two column in my table (custom_avail_history) and if they do not match, insert the record into another table (custom_avail_history_changelog) to track changes over time. When I try using the code below it tells me "ERROR 1054: 1054: Unknown...

It was an issue with my primary key settings. I see what you are talking about reassigning the variables. I was running the two select queries because I did not know how to insert into 2 different columns from the same query. Thank you for help. I learned a lot from your optimization.

Can anyone tell me why my insert statement in the loop is only inserting the first record? The code completes 5 trips through the loop and it is selecting different sets each time through (I can see the sets with the echo at the end of the loop), but it only inserts the first set. $count = 0...

I'm not sure what you mean when you say "use the shell"?

The code below creates the table and inserts the rows, but it runs very slow. Is there a better method of inserting the results into my table? The select query could run as high as 18,000 rows depending on the time frame. Any direction on how to do this more efficiently would be appreciated...

Can I ask why you don't send your email using the CDO or Outlook library instead of this special utility?

Isn't that what is holding my header in place when I scroll through the body?

Ok I really need this to work, and I've been beating my head against the wall too long already so any help would be GREATLY appreciated. Everything is working great with code show below except, the column widths in the tbody do not match the column widths in the thead which is a fixed row...

Thanks for the example spamjim. I have the scroll function working great but my header row still scrolls with the rest of the table. Can you give me some insight into what I did wrong here? echo '<div id="tableContainer" class="tableContainer">'; echo '<table border="1" width="99.9%"...

How can I make the below code display with a locked header so that when the user is scrolling down the display the header of the table is still visible? I have tried displaying a table with just the header and then a scrollable table below it, but then the columns do not match up because the...

How can I make the below code display with a locked header so that when the user is scrolling down the display the header of the table is still visible? I have tried displaying a table with just the header and then a scrollable table below it, but then the columns do not match up because the...

The code you posted at 24 Sep 13 19:31 did exactly what I needed. It properly placed the higher priority values. Thank you so much for all your help!!!

You would use [Forms]![FormName]![TextBoxName] as the criteria in the date field of your query.

I will try these as soon as a get back in the office tomorrow. Thank you so much.

If I use the print_r($rows) to display the array the column numbers match for the different priority rows (but it does not display in a user friendly format). Does the echo table not know how to handle the column numbers?

The new code ran with the same results. It writes the first priority line correctly, but does not position the additional priority values correctly. I'm not sure what you mean by "sql compliant dump format"

The query runs, but when we change priorities it does not skip the zone if it does not have a value. For example, the code is returning: Priority | A | B | C | 1 | 10 | 5 | 2 | 2 | 1 | | | 3 | 1 | | | But it should of returned...

I'm fine with dumping the array, but I keep getting a HTTP 5000 Internal Server Error, and I thought it might have been caused by the way I was attempting to display the results.

First of all, THANK YOU for your help! I am new to using php, so forgive me if my questions sound stupid. It would be run multiple times throughout the day, and it is running against an informix database. When I run my query, it returns 35 zones with 511 transactions and 4 priorities. This...

Does this make more sense? Current code displays this: Zone | Priority | Trans A | 2 | 50 A | 3 | 10 B | 2 | 5 But, I need the results to look like this: [tab] | A | B | 2 | 50 | 5 | 3 | 10 | The Zones would be my column headers, Priorities would...