Incorrect syntax error

[omansur]

Well one was the hosting company we have now is 2coolweb (dot) com. and now we are trying to move to 1and1 (dot) com.

I just imported the BAK file to 1and1. The Newpak (dot) com site is working fine. I really don't understand why we are having this problem. This is a StoreFront shopping cart we are running.

Why am I having all these problem?

Thanks for all your help,

omansur

[omansur]

I went into the the sql DB to check if the order was writen. None of the orders are being writen to the DB. I won't even know where to begin looking.

O

[Arch_Angel]

Did you fix the last error you got? Did you also remember to remove the code I asked you to add?

Response.Write sql
Response.End

[omansur]

Yes the last one did work. Not more errors show up in the browser, but the orders don't post to the database.

Yes I did remove the code you asked me to insert.

Would you be will to look at my code?

O

[Arch_Angel]

Sure. I'll take a look at it.

Can email me a link to the site so we can test it.

[omansur]

Can you please send me an email with the info you need... I think you have the address.

omansur

[Arch_Angel]

I sent you an email. We can work it out there.

[CGPGroup]

I dont see anything wrong with the syntax of your SQL statement. try putting angle brackets around your column name to explicitly tell the parser to treat them as column names and not reserved words.

if you have enterprise manager and/or query analyzer, try connecting to the Instance of SQL server and run your query. query analyzer should give you a better error message. also try checking your connection string.

[Arch_Angel]

He got that fixed CGP. It just needed quotes around the field because it was a text field.

The problem he is having is the info is not being inserted into the database.

[editor]

He got that fixed CGP. It just needed quotes around the field because it was a text field.

The problem he is having is the info is not being inserted into the database.

where is the "insert" or "update" sql statement?