Subject RE: [firebird-php] Re: php4-interbase and select with no result
Author Darren Thompson
I have found that interbase/firebird is very sensitive to single qoutes or
double it sometimes works in scripts having the single qoutes inside the
double but generally it dosent work i always escape it if a single qoute is
needed for char or varchar.

-----Original Message-----
From: hbanjo9000 [mailto:hbanjo9000@...]
Sent: 08 August 2004 16:02
Subject: [firebird-php] Re: php4-interbase and select with no result

> so if you echo the query everthing is cool well i think its the
code thats
> the problem not a configuration setting
> "SELECT * FROM ECC WHERE MCC = ".'92000000001001';
> try that with the query and dont use star use the fieldname!

YES!!! IT WORKS!!! thanks a lot.... but what's the magic?
Before that I tried to insert fieldnames instead star without
solution, but keeping single quotes outside double
it's new for me. I never think it before because the old way
it always works.
That's merging both tips (fieldname and single quotes outside)
the winning choice.

thanks again


Yahoo! Groups Sponsor

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]