Barry,
I suspect you might have more luck sending your question to a
PowerBuilder list (what is it anyway ? A Borland product ?), althought
you might have some luck here...
regards,
P
On Tue, 24 Apr 2001, Barry Reynolds wrote:
> I am having a problem with setting up a query in using MySql. The query uses a
> user-defined parameter and searches the table against it. e.g.
>
> int search //user peramater
>
> select * from table
> where member_id = :search;
>
> When trying to run this query (using powerbuilder) it doesnt return the desired
> row. However if i use the following query (using a hard-coded member_id), it
> does work,
>
> select * from table
> where member_id = 0001;
>
> I have feeling it is a problem with one of the ODBC options in the database
> profile. If anyone could help me i would be really thankfull,
> Thanking you in advance,
> Barry.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
-----------------------------------------------
Peter Skipworth
Perl Developer/Unix Systems Administrator
[EMAIL PROTECTED]
+44 795 055 0029
-----------------------------------------------
4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61
20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
