Re: Re: Conversion to T-SQL

WHERE ? >= 0
[download]

I am not sure this will actually work. The DBI will quote each parameter passed with a placeholder. This is a column name, not a value.

Comment on Re: Re: Conversion to T-SQL Download Code

Replies are listed 'Best First'.
Re: Re: Re: Conversion to T-SQL by Aragorn (Curate) on Jan 26, 2004 at 15:04 UTC
What is the meaning of `...WHERE" . $_ . " >= 0")` then? Aren't comparing the column name there too? Arjen	[reply] [d/l]
Re: Re: Re: Re: Conversion to T-SQL by Anonymous Monk on Jan 26, 2004 at 21:56 UTC
`"...WHERE " . $_ . " >= 0"` results in `...WHERE columname >= 0`, while your code would produce `...WHERE 'columname' >= 0` Can you see the difference?	[reply] [d/l] [select]