Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
After Update Trigger?
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... -
Insert in Loop not working
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. -
Insert in Loop not working
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... -
Insert odbc results into mysql?
I'm not sure what you mean when you say "use the shell"? -
Insert odbc results into mysql?
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... -
Error initiating communication with Smtp server. (501)
Can I ask why you don't send your email using the CDO or Outlook library instead of this special utility?- benderulz
- Post #4
- Forum: Visual Basic (Classic)
-
Table Body colums do not match fixed header
Isn't that what is holding my header in place when I scroll through the body?- benderulz
- Post #3
- Forum: HTML, XHTML & CSS
-
Table Body colums do not match fixed header
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...- benderulz
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
Trouble Displaying query results
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%"...- benderulz
- Post #4
- Forum: HTML, XHTML & CSS
-
Trouble Displaying query results
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...- benderulz
- Thread
- Replies: 4
- Forum: HTML, XHTML & CSS
-
Trouble displaying query results
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 do I change this to a crosstab?
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!!! -
use access form textbox with date to run query
You would use [Forms]![FormName]![TextBoxName] as the criteria in the date field of your query.- benderulz
- Post #2
- Forum: Microsoft: Access Forms
-
How do I change this to a crosstab?
I will try these as soon as a get back in the office tomorrow. Thank you so much. -
How do I change this to a crosstab?
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? -
How do I change this to a crosstab?
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" -
How do I change this to a crosstab?
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... -
How do I change this to a crosstab?
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. -
How do I change this to a crosstab?
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... -
How do I change this to a crosstab?
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...
