This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » SQL syntax error on line 1

SQL syntax error on line 1
Vivian Tirabassi Member Since: 29 Nov 2008 Posts: 3	Posted 29 Nov 2008 22:49:00 I've been getting this error message on my shopping cart: "Could not perform query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.pid=a.id' at line 1" There isn't any 'AND c.pid-a.id' at line 1, it's on line 17. Is there any way i can fix this? Thank you, Vonique I've been getting this error message on my shopping cart: "Could not perform query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.pid=a.id' at line 1" There isn't any 'AND c.pid-a.id' at line 1, it's on line 17. Is there any way i can fix this? Thank you, Vonique

SQL syntax error on line 1

Vivian Tirabassi
Member

Since: 29 Nov 2008
Posts: 3

Posted 29 Nov 2008 22:49:00

I've been getting this error message on my shopping cart:

"Could not perform query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.pid=a.id' at line 1"

There isn't any 'AND c.pid-a.id' at line 1, it's on line 17.

Is there any way i can fix this?

Thank you, Vonique

I've been getting this error message on my shopping cart:

"Could not perform query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.pid=a.id' at line 1"

There isn't any 'AND c.pid-a.id' at line 1, it's on line 17.

Is there any way i can fix this?

Thank you, Vonique

Vince Baker Zone Administrator Since: 10 Dec 2001 Posts: 809	Replied 04 Dec 2008 16:36:05 Hi vivian, That is probably stating the sql error rather than the location on your page. Can you post the whole code so I can see the sql command you have coded? Regards Vince Baker <strong>DMX Zone Manager</strong> [VBScript \| ASP \| HTML \| CSS \| SQL \| Oracle \| AS400 \| ERP Logic \| Hosting]

Vivian Tirabassi Member Since: 29 Nov 2008 Posts: 3	Replied 04 Dec 2008 16:40:58 <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Hi vivian, That is probably stating the sql error rather than the location on your page. Can you post the whole code so I can see the sql command you have coded? Regards Vince Baker <strong>DMX Zone Manager</strong> [VBScript \| ASP \| HTML \| CSS \| SQL \| Oracle \| AS400 \| ERP Logic \| Hosting] <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Vivian Tirabassi Member Since: 29 Nov 2008 Posts: 3	Replied 04 Dec 2008 16:42:58 Hello, I have already solved that problem. Thank you, though.

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

SQL syntax error on line 1

Reply to this topic

Live Support

On Sale

DMXzone Tabs

Advanced HTML Editor 3

Image Gallery Add-on

File Manager Add-on