U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » '?' make errors

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

'?' make errors [message #20757]

Sun, 05 April 2009 01:07

TeCNoYoTTa
Messages: 138
Registered: July 2008
Location: Egypt

Experienced Member

hello all

why when i try to execute a query like this

insert into FILES values (432,2,2,3,"section-3.pdf","1.2 MB"," http://cisclub.com/forum/attachment.php?attachmentid=4256&am p;d=1238883167","")

the programs have run time error

and when i remove the '?' from the link there is no errors ?

Report message to a moderator

Re: '?' make errors [message #20760 is a reply to message #20757]

Sun, 05 April 2009 09:40

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

Please, next time, more info....

Anyway, if you do this:

sql.Execute("insert into FILES values (432,2,2,3,\"section-3.pdf\",\"1.2 MB\",\" http://cisclub.com/forum/attachment.php?attachmentid=4256&am p;d=123888316\7",\"\")");

then the problem is that ? is a placeholder for actual parameter.

Mirek

Report message to a moderator

Re: '?' make errors [message #20762 is a reply to message #20760]

Sun, 05 April 2009 12:16

TeCNoYoTTa
Messages: 138
Registered: July 2008
Location: Egypt

Experienced Member

yes i mean that !!

how can i fix it ??

thx in advance

Report message to a moderator

Re: '?' make errors [message #20763 is a reply to message #20762]

Sun, 05 April 2009 12:57

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

TeCNoYoTTa wrote on Sun, 05 April 2009 06:16

yes i mean that !!

how can i fix it ??

thx in advance

- use SqlExp

- or use placement parameter(s):

SQL.Execute("insert into FILES values (?,?,?,?,?,?,?)",
            432,2,2,3, "section-3.pdf", "1.2 MB",
            "http://cisclub.com/forum/php?attachmentid=4256&am p;d=123888316",
"");

Mirek

Report message to a moderator

Re: '?' make errors [message #20774 is a reply to message #20763]

Mon, 06 April 2009 00:14

TeCNoYoTTa
Messages: 138
Registered: July 2008
Location: Egypt

Experienced Member

Thanks Alot Mirek

Report message to a moderator

Previous Topic:	PostgreSQL example does not save data to database
Next Topic:	Does SQLite is thread safe?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 20 14:47:03 CEST 2024

Total time taken to generate the page: 0.01541 seconds