forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


[resolved] Does vdsmysql addslashes work ?

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    forum.vdsworld.com Forum Index -> General Help
View previous topic :: View next topic  
Author Message
X-Tools
Valued Contributor
Valued Contributor


Joined: 20 Sep 2001
Posts: 296
Location: Germany

PostPosted: Tue Sep 28, 2004 8:22 am    Post subject: [resolved] Does vdsmysql addslashes work ? Reply with quote

Hi,

does vdsmysql.dll - @mysql(addslashes really work ?

I never had any problems with it - also inserting memos with slashes into mysql worked fine.

But now I have to set queries dynamically using variables.

So I wanted to use
field = '@mysql(addslashes,%%content)'

But this seems not to work. Possibly addslashes does only work inside a mysql query command`?

Here is an example script:

Code:
  directory change,@path(%0)
  external vdsmysql.dll
  #define command,mysql
  #define function,mysql

 
  %%var = test@chr(34)var@chr(34)test
  info var: %%var@cr()escaped: @mysql(addslashes,%%var)
Back to top
View user's profile Send private message Send e-mail Visit poster's website
X-Tools
Valued Contributor
Valued Contributor


Joined: 20 Sep 2001
Posts: 296
Location: Germany

PostPosted: Tue Sep 28, 2004 9:50 am    Post subject: Reply with quote

Hi,

sorry - found my mistake.

Quotes becomes masked, not double quotes.

Bye, Fabian
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   This topic is locked: you cannot edit posts or make replies.    forum.vdsworld.com Forum Index -> General Help All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group