|
| |
|
|
Cornelius
Posts: 14
Joined: 3/18/2004
Status: offline
 |
'::whatever::' will not work!! - 3/18/2004 11:30:41
I've seen some references to people having problems when trying to pass parameters in a URL to a page using the DRW. I can do it in a basic query, but I cannot get it to work when I do a custom edit. Here is the very simple statement I am trying to use. I am pulling from two tables in the database, using FP2002.
SELECT fulltitle, ID, auth_id
FROM author, books
WHERE author.id = books.auth_id
AND ID = '::ID::'
I use a url such as http://65.36.133.186/author2.asp?ID=Albom
This is pretty simple, but it won't work! I've tried just about every variation imaginable. I always get an error message as follows:
Database Results Error
The operation failed. If this continues, please contact your server administrator.
If I set the parameter to a fixed name, such as ID = "Albom" it works fine. Either Frontpage or the server is just not accepting the '::' thing. I've seen other posts referring to a similar situation, but not exact.
Thanks,
Cornelius
|
|
|
|
Cornelius
Posts: 14
Joined: 3/18/2004
Status: offline
|
RE: '::whatever::' will not work!! - 3/18/2004 15:23:22
True error:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
One or more form fields were empty. You should provide default values for all form fields that are used in the query.
| |
|
|
|
Cornelius
Posts: 14
Joined: 3/18/2004
Status: offline
|
RE: '::whatever::' will not work!! - 3/18/2004 15:27:34
After seeing the true error, I went into DRW and set a default of % for the only field that appeared the the "Defaults" box, which was ID. Now, this is the error, without the last paragraph now:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
Thanks!!
< Message edited by Cornelius -- 3/18/2004 15:38:14 >
| |
|
|
|
Cornelius
Posts: 14
Joined: 3/18/2004
Status: offline
|
RE: '::whatever::' will not work!! - 3/19/2004 7:35:57
OK, I think I got this one working, although I'm not sure how. I did have one field name spelled wrong, but correcting that didn't fix it. Then I started from scratch one step at a time and kept building on statements, tweaking occassionally, and viola! It worked.
Thanks,
Cornelius
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 