ASP Coding Strangeness
I have been using MySQL for years but today I am stymied.
I wrote a simple ASP program to tell me how many records are in a particular table:
The select string =
SELECT COUNT(*) FROM Products
After I execute it using a recordset called 'rs, I display the contents of what is returned (rs(0)) and it properly shows me that there are 14 records in the table.
But if I run an even simpler select string on that table
SELECT * FROM Products
I get rs.eof (a return indicating no records found.)
What in the world could cause such behavior?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Help With SQL Coding
I have three tables: table1: table2_ID table3_ID complete table3: table3_ID name table2: table2_ID table4_ID Given table3.table3_ID, I need to retrieve the value of table1.complete OR "Not Complete". I have tried this in several different iterations without success. SELECT IF(ISNULL(e.complete), e.complete,'Not Complete') as complete FROM table3 s RIGHT OUTER JOIN table1 e ON e.table3_ID = s.table3_ID INNER JOIN table2 t ON t.table2_ID = e.table2_ID WHERE s.table3_ID = 2993 AND t.table4_ID = 10029.
View Replies !
View Related
SQL Coding
I need some help writing a sql script to run in phpMyAdmin. I have a table (one of many) called products. Inside, there is a field called product_id. That same record then has another field called product_ship_price. I have a list of product_id's that I need to change the product_ship_price. Can someone give me the SQL to do this? I know it's simple, I just don't know all of the SQL commands.
View Replies !
View Related
Coding In General
I just started a website, and am trying to run phpbb on it. I installed (I believe correctly) php and (again, I believe correctly) MySQL. I have enabled the MySQL extension in the php.ini, and added the extension_dir field for the lbrmysql.dll as well. When I try to run the install.php now for the phpbb, I now get a CGI time out. If I undo the changes I made, then it tells me it can't access MySQL. I know that I have PHP issues as well, but most of my problems seem to stem from the fact I have no clue how to configure the relationship between SQL and PHP. Please tell me where to start looking, and any information I need to post to help give an idea of what's going on.
View Replies !
View Related
DataBase Coding
I have converted most of my applications over to C++ with Windows but have stayed with the DBF files. I an currently producing some basic html pages and using Javascript functions which are very much like C. I now need to do some database work. i.e. allow my users to id themself and then present them with choices based on their ID. Can I do this on the server side with JavaScript?
View Replies !
View Related
|
TRACKER
