Query Parameters and Regular Expression

[Danilo Corallo]

Hi to all, I working to a query tool. The user can load a query and execute it. Some queries can contain "variables". I looked on Internet and I found they can have different aspect. The Microsoft provider executes with no problem, queries like:* SELECT * FROM Table WHERE ID = :variable I'm trying to execute queries like:

• SELECT * FROM Table WHERE ID = ?
• SELECT * FROM Table WHERE ID = &variable
• SELECT * FROM Table WHERE ID = &<name="variable1" type="string"> They are named as follow:
• Oracle style bindings
• JDBC style bindings
• Name unknown (used for example by QueryReporter)
• Name unknown (used for example by QueryReporter) To do that I've wrote a Regular Expression for each type.
• "[\s]*?:[\s]*?([A-Za-z0-9^\s^<^,]*)"
• "[\s]*?([\?])[\s^,^<]*?"
• "[\s]*?&[\s]*?([A-Za-z0-9_^\s^<^,]*)"
• "&[\s]*?<[\s]*?[nN][aA][mM][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?([tT][yY][pP][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?)?>" My problem is this one: I want to exclude the strings contained inside "" or '' e.g. I don't want to match ":this" because it's not a variable to bind SELECT * FROM Table WHERE Column = "Hello world :this is me" Hope I've been clear Thanks in advance ;P

[J4amieC]

Danilo Corallo wrote:

Hope I've been clear

You've not been clear at all... try asking a question for starters

[Danilo Corallo]

I need a Regular Expression to match the bold part: SELECT * FROM Table WHERE ID = ¶meter but not this one SELECT * FROM Table WHERE ID = "Me&You" Thanks