customer_order_details.php

6/08/2011 2:24 pm | #1 cicyou421883

Items are in Database, orders and orderdetails

Trying to make the pages for looking at order history.

customer_order_details.php

Unknown column 'WADAOrderID' in 'where clause'

6/08/2011 3:28 pm | #2 cicyou421883

Where Clause

The database is not seeing the page that I created with Webassist I am hosting with Godaddy and they use Starfied technolgies for the database, which is accepting products and orders.

6/09/2011 7:53 am | #3 Jason ByrnesWebAssist

the error Unknown column 'WADAOrderID' in 'where clause' is because the recordset on the order details page is missing a parameter.

edit the recordset, in advanced view, create a new variable in the variables section:

Name: WADAOrderID
Type: Number
default Value: -1
Run Time Value: $_GET['OrderID']

6/09/2011 11:58 am | #4 cicyou421883

Recordset Attempt

Hey Jason- 2 things happen. Type: only choice says "Floating Point Number" - Is it okay to choose? When I did and hit okay Error:

Please enter a SELECT Statement
WADAOrderID is an invalid variable name; it does not appear in the SQL

I used e-commerce for the SQL

Thanx again, Cathy

6/09/2011 12:07 pm | #5 Jason ByrnesWebAssist

there should be a selection for integer, use that one.

it sounds like you are createing a new recordsert not editing the existing record set on the order details page.

Double click the WADAOrders recodset on the order details page to edit it.

6/09/2011 2:01 pm | #6 cicyou421883

Same error message

Changed the variable with your instructions, uploaded to site and same error comes through

Unknown column 'WADAOrderID' in 'where clause'

Retosred .msql file in database to make sure.... all WA files were put... Any more ideas? Right now I am amually going into the database. Thanx, Cathy

6/09/2011 2:04 pm | #7 Jason ByrnesWebAssist

make a visual change to the page and re upload it to ensure that the upload is actually going up.

If you can versify that the code changes are actually making it to the server, and still have the same issue, send a copy of your page so I can view the code.

6/09/2011 6:40 pm | #8 cicyou421883

verified put successful

The page is uploaded, refreshed and verifies. Error still there, Sending Attachment - Thank you!

Sorry I sent it the wrong way - shame on me - I knew better. learning still. Will this zip work?

Attached Files

customer_order_details.php.zip

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

customer_order_details.php

6/08/2011 2:24 pm | #1 cicyou421883