|
| |
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
 |
s-columnnames Problems Still Going - 6/4/2004 16:50:15
Hi,
This page contains the authors. http://hoopsking.com/browse_coaches3.asp
Click the last name and you are supposed to see a list of the videos they have authored. I had this working before my hosting company goofed up a bunch of stuff (www.halfpricehosting.com)
Here is the Microsoft Article fix link:
http://support.microsoft.com/default.aspx?scid=kb;[LN];817029
Here is my custom query:
SELECT [Catalog Quick Find].ItemNumber, [Catalog Quick Find].ItemName, [Catalog Quick Find].URL
FROM Author INNER JOIN [Catalog Quick Find] ON Author.CoachID = [Catalog Quick Find].Author
WHERE (((Author.CoachID)=::CoachID::));
I've tried converting it to an aspx page without success (FP 2003 recommends to use asp). I've checked on the S-column names and all the fields are there. Here is the code:
<!--webbot bot="DatabaseRegionStart" s-columnnames="ItemNumber,ItemName,URL" s-columntypes="202,202,202"
I'm at a loss as what to do next. Any ideas?
|
|
|
|
DesiMcK
Posts: 446
Joined: 4/26/2004
From: Essex, UK
Status: offline
|
RE: s-columnnames Problems Still Going - 6/4/2004 18:01:34
Is ItemNumber a text field or a number field. If it is number then try changing the first 202 to 5.
Desi
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/7/2004 19:18:44
Not sure why you are using a JOIN as you are not displaying any fields from the Author table. Why not this SQL:
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author = ::CoachID
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/8/2004 15:09:57
The Item # is a text field.
betheball, I changed to your SQL and there is still an error but doesn't seem to be as bad as the other. Here is the link now with a Coach ID:
http://hoopsking.com/browse_coaches_display3.asp?CoachID=44
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/8/2004 15:33:27
Bad cut and paste. I missed the last two colons:
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author = ::CoachID::
If the above also generates an error, try:
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author = "&Request.QueryString("CoachID")&"
< Message edited by betheball -- 6/8/2004 13:35:46 >
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/9/2004 15:51:23
The first query returned an error and the 2nd looks to be incomplete. The query I had originally worked except after moving to Frontpage 2003.
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/9/2004 17:58:39
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author = "&Request.QueryString("CoachID")&"
The above is not incomplete. I did gave you that to see if perchance your server was simply not recognizing FP's ::formfield:: format. For example, if the above worked it may point to a server extensions problem. If you hard code a value in to the SQL does the page work?
For example, does the page at least display a record if you change your SQL to:
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author = 44
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 15:45:56
Yes, that does return the results.
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 16:03:39
So, did you try this one?
SELECT ItemNumber, ItemName, URL FROM [Catalog Quick Find] WHERE Author = "&Request.QueryString("CoachID")&"
Also, is the CoachID field in the Author table numeric?
< Message edited by betheball -- 6/10/2004 14:04:33 >
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 16:13:32
That one returns a server error when I try to verify it. Here is the Details:
Server error: Unable to retrieve schema information from the query:
SELECT ItemNumber, ItemName, URL FROM [Catalog Quick Find] WHERE Author = "&Request.QueryString("CoachID")&"
against a database using the connection string
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=database/catalog_quick_find.mdb.
The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Author = [&Request.QueryString(]CoachID[)&]'.
Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
Yes, the Coach ID is numeric.
< Message edited by hoopsking -- 6/10/2004 16:14:39 >
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 16:21:20
Even though the query won't verify, it may work. FP sometimes won't verify a query that's not written in FrontPagese. Have you ever used the Spooky Diet? (See link in my signature). If you diet the code, you can go into HTML view and replace the existing SQL statement with the one I provided.
Out of curiosity, try creating a new page and and use the DRW to query the Catalog Quick Find table. In step 3, choose "Options" and "Criteria" and choose Author as your criteria. The in step 5 make sure you click the "Add Search Form" option. Save the page, enter say 44 in the test form and submit. See if that returns the same error.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 16:37:05
It won't even let me paste it in there and click ok. The error message pops up.
I created the test page and it did return results. Here it is:
http://www.hoopsking.com/catalog_quick_find_test.asp
I have 2 tables for this query. One contains the coach ID, First Name, and Last Name. The other table has the Item #, Item Name, Item URL and the Author (Number field).
The thing I don't get is that this all worked before.
I've looked over the Spooky Diet before.
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/10/2004 17:13:43
quote:
The thing I don't get is that this all worked before.
Nor do I. It is very strange. Here is another test you can try. Create a new page and on it insert a form with just one text box. Name the text box CoachID. Then, right-click the form. Choose "Form Properties" and mark the "Send to Other" box. In the Action, enter browse_coaches_display3.asp. Save the page (it can be .htm or .asp). On browse_coaches_display3.asp go back to the SQL of:
SELECT ItemNumber, ItemName, URL
FROM [Catalog Quick Find] WHERE Author=::CoachID::
Open the page with the form you created and enter a CoachID and submit. Does that work?
Just curious, have you tried re-creating browse_coaches_display3.asp from scratch?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
hoopsking
Posts: 165
Joined: 1/16/2002
From:
Status: offline
|
RE: s-columnnames Problems Still Going - 6/11/2004 10:27:21
I recreated the page in FP 2002 and used both of your SQL statements and my original. This one would not work at all:
SELECT ItemNumber, ItemName, URL FROM [Catalog Quick Find] WHERE Author = "&Request.QueryString("CoachID")&"
and my original and your other one both came back with the S column error.
< Message edited by hoopsking -- 6/11/2004 10:36:34 >
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: s-columnnames Problems Still Going - 6/11/2004 10:42:19
If interested, you can zip up a copy of the database, browse_coaches3.asp and browse_coaches_display3.asp and send them to me on email for a closer look. Did your host recently change to Server 2003? That may be why the page stopped working. Anyway, if interested, you can PM or email me for my email address.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 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 
