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
To: firebird-php@yahoogroups.com
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

Haran



Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

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



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