martin_walker
Posts: 2
|
| Posted: 04/15/2008, 9:50 PM |
|
I keep getting these errors both in my local linux box running MySQL 5.0.45 and also on a free webhost running: MySL 5.0.27
I have exported the sql from my local phpmyadmin and imported into the web host.
This is from the Portal example using codecharge studio 4 trial to see if it will work for me ( so far not much luck)
errors:
Database Error: 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 '{SqlParam_endRecord} * FROM articles ORDER BY article_id LIMIT 0,10' at line 1
also:
Database Error: 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 '{SqlParam_endRecord} link_name, link_url FROM links WHERE ( is_approve=1 ) O' at line 1
Database Error: 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 '{SqlParam_endRecord} * FROM events ORDER BY event_id LIMIT 0,10' at line 1
you get the idea...
any help appreciated
|
 |
 |
DonB
|
| Posted: 04/17/2008, 4:47 AM |
|
Whatever {SqlParam_endRecord} is, it shouldn't be there.
--
DonB
"martin_walker" <martin_walker@forum.codecharge> wrote in message
news:54805857cee600@news.codecharge.com...
>I keep getting these errors both in my local linux box running MySQL 5.0.45
>and
> also on a free webhost running: MySL 5.0.27
> I have exported the sql from my local phpmyadmin and imported into the web
> host.
>
> This is from the Portal example using codecharge studio 4 trial to see if
> it
> will work for me ( so far not much luck)
>
>
> errors:
>
> Database Error: 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
> '{SqlParam_endRecord} * FROM articles ORDER BY article_id LIMIT 0,10' at
> line
> 1
>
> also:
>
> Database Error: 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
> '{SqlParam_endRecord} link_name, link_url FROM links WHERE (
> is_approve=1 ) O'
> at line 1
> Database Error: 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
> '{SqlParam_endRecord} * FROM events ORDER BY event_id LIMIT 0,10' at line
> 1
>
> you get the idea...
>
> any help appreciated
>
>
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
martin_walker
Posts: 2
|
| Posted: 04/17/2008, 8:02 AM |
|
Quote DonB:
Whatever {SqlParam_endRecord} is, it shouldn't be there.
--
DonB
That's the code that Codecharge studio generated.
I'm not fighting with it, I have decided to go with a different product
|
|
|
|
Stanj
Posts: 166
|
| Posted: 04/17/2008, 9:22 AM |
|
Normally, no fighting is required, the RAD tool works very well and generates good code. I take it you are using the free download. It is possible the download was faulty? Try dowloading again as a test, it does work. No one on this forum has had a similar problem so it is safe to safe it is not due to bugs in the code.
What product are you thinking of replacing it with?
_________________
Stan
St Petersburg Russia |
|
|
|
|
