| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 48927 | 2004-09-05 05:54:00 | ASP Database problem | george12 (7) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 269410 | 2004-09-06 11:49:00 | anther thing to check is... This commonly occurs when your field name is a reserved word . Adjust your field names and SQL statement accordingly and you should avoid the problem. |
robsonde (120) | ||
| 269411 | 2004-09-07 03:28:00 | mmm. Maybe a field name of "Field" and a variable name of "Value" might be pushing your luck with reserved words. :D If this software has reserved words. ? ;-) Ignorance is bliss in my case. | Graham L (2) | ||
| 269412 | 2004-09-07 03:36:00 | Perhaps there is no Username of "George" or whatever you're testing with?? | antmannz (28) | ||
| 269413 | 2004-09-07 12:00:00 | > Perhaps there is no Username of "George" or whatever > you're testing with?? LOL I wish it were that simple. Yes, George does exist. If not, it would tell me as I've already got the error handling sorted. The strange thing is I know the statement MUST be right because it works in my other scripts. So, it MUST be the data being passed into the function. But I've check that for validity too! :_| I am completely baffled by this illogical problem |
george12 (7) | ||
| 269414 | 2004-09-07 13:30:00 | George, I am not being nasty, or getting at you, I do not Know enough about what you are doing here to comment, although I do understand it. Unbiased observation. You read a long complex post, you missed one or two vital parts, caused you to make a slightly off statment. Programming faults, like Tellers banking faults. They made it, they cant see it. Get some one else to read the script. I might learn something from the thread then. |
drb1 (4492) | ||
| 269415 | 2004-09-07 14:13:00 | is "password" a reserved word?? see what happens if you re-write the database and scripts to use "paswd" insted of password. |
robsonde (120) | ||
| 269416 | 2004-09-07 14:18:00 | what CAPS do you have on the word "password" in your database design? is it Password or is it PassWord? or is it just password? |
robsonde (120) | ||
| 269417 | 2004-09-07 15:22:00 | I don't know ASP, but too me the problem is before line 16 MyConn.Open("PROVIDER=Microsoft.Jet. OLEDB.4.0;DATA SOURCE=c:\Domains\jgih.com\db\users.mdb;") Should that semi-colon be there? From my perspective it's incorrect on other languages I'd base it on C/C++ Hope that is the problem. |
chameleon_coder (6050) | ||
| 269418 | 2004-09-07 15:28:00 | Here's a site that should help with the script. support.microsoft.com |
chameleon_coder (6050) | ||
| 269419 | 2004-09-08 02:56:00 | I'm going to try every one of you're suggestions one by one and see what happens. I will report back in about 30 mins. Chameleon_coder, your site was slightly irrelavent as my database is not password protected. You're help appreciated though. Cheers George |
george12 (7) | ||
| 1 2 3 | |||||