asked on
Javascript Regex
Hello all,
Im trying to create a function that would search through a string and then replace :something with '$something'
For example:
select * from internal where id = :id and name=:kn_op_id
would result in
select * from internal where id = '$id' and name='$kn_op_id'
Can anyone help?
Im trying to create a function that would search through a string and then replace :something with '$something'
For example:
select * from internal where id = :id and name=:kn_op_id
would result in
select * from internal where id = '$id' and name='$kn_op_id'
Can anyone help?
JavaScriptRegular Expressions
Last Comment
Julian Hansen
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi, for the first match its actually coming back as id = '$1' instead of $id
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Why have you posted this to the JavaScript Topic Area - is there a JavaScript component to it - looks more like MySQL / PHP
@Julian: that's plain SQL.
If the OP wants to modify SQL queries using JS, where is the problem?
If the OP wants to modify SQL queries using JS, where is the problem?
ASKER
Julian - its a javascript question regarding regex manipulation of a string.
@Dan,
Just trying to establish what the background is - when you see an SQL query with $ variables (PHP) in a JavaScript context it raises questions - I was just making sure I completely understand the context before attempting a solution.
Just trying to establish what the background is - when you see an SQL query with $ variables (PHP) in a JavaScript context it raises questions - I was just making sure I completely understand the context before attempting a solution.