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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ASP/MySQL SELECT and INSERTs do ot work.
Hi there, Yes, I see why you would say that. Actually, it is doing what I want. I have an admin only area for my client to update the news page and he can specify when he wants the news to appear on the website, and since he will not put an old date in (otherwise it wouldn't be news) then it...- peeechy3
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP/MySQL won't select or Insert! Help!
Hi, I'm using ASP not PHP so don't worry. The date is in YYYY-MM-DD format, but thanks. I've deduced that I have a locked host as I've made too many interupted connections so I need to get that sorted first now. I think the select is a VBScript prob mind. Thanks for your help anyway. -
MySQL/ASP/VBScript SELECT and loop not working.
Yes, will do. Thanks for your help anyhow and I've been able to dedue the host lock at least. Thanks again! -
MySQL/ASP/VBScript SELECT and loop not working.
Just found this in the documentation, i think it will be a support job: If you get the following error, it means that mysqld has received many connect requests from the host 'host_name' that have been interrupted in the middle: Host 'host_name' is blocked because of many connection errors... -
MySQL/ASP/VBScript SELECT and loop not working.
I've got a feeling I will have to ask my host support to do this for me... which will take days evertime something like this happens! Blimey! I just went into MySQL MyAdmin and saw the command Flush Table so I clicked it and got this back: Error SQL-query : FLUSH TABLE `NEWS` MySQL... -
MySQL/ASP/VBScript SELECT and loop not working.
Hi, Thanks both of you. I reckon you are both right. I just took off the ON ERROR RESUME NEXT and got this: ADODB.Recordset.1 error '80004005' SQLState: S1000 Native Error Code: 1129 [TCX][MyODBC]Host 'localhost.localdomain' is blocked because of many connection errors. Unblock with... -
MySQL/ASP/VBScript SELECT and loop not working.
Hi there! I already have a bit that prints out my SQL query to screen: <% If DebugMode = "True" Then %> SQL Code = <%=SQL%><BR> <%=TodaysDate%> <% End If %> On screen it is as it should and I have already tested it in the tool which returns the two rows. I'm confused. -
MySQL/ASP/VBScript SELECT and loop not working.
I am completely new to using a MySQLDB but I'm surprised that this doesn't work. Basically, I'm selecting all records from my NEWS database table. There are definately two rows of test data in the NEWS table so they should be fetched row by row, but without the loop on, nothing is returned... -
ASP/MySQL SELECT and INSERTs do ot work.
I am completely new to using a MySQLDB but I'm surprised that this doesn't work. Basically, I'm selecting all records from my NEWS database table. There are definately two rows of test data in the NEWS table so they should be fetched row by row, but without the loop on, nothing is returned...- peeechy3
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP/MySQL won't select or Insert! Help!
I am completely new to using a MySQLDB but I'm surprised that this doesn't work. Basically, I'm selecting all records from my NEWS database table. There are definately two rows of test data in the NEWS table so they should be fetched row by row, but without the loop on, nothing is returned...
