| Programming PHP | PERL | ASP| ColdFusion| C++ Chat with other forum members about programming. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
CERFnet__x_billers__ __billed_by_desc____x_billers__Results are concatenated (e.g., if CERFnet and IBS selected, value in $p_billed_by is "CERFnetIBS").my $cgi = new CGI;my %params = $cgi->Vars;my ($p_billed_by) = $params{'billed_by'} || "";I added a space in the HTML code:CERFnet __billed_by_desc__Then, used a split command to create an array:@p_billed_by = split (/ /, $p_billed_by);Strange results:"AND billed_by = '$p_billed_by[0]'"; works fine but"AND billed_by = '$p_billed_by[1]'"; errors with SQL: -282: Found a quote for which there is no matching quote.Two questions:Is it correct for the Select Multiple to send a concatenated value?Why will Informix not prepare the cursor for the query if it uses another element in an array besides the first? Query works in dbaccess.Thanks for the reply.That is what I thought - that select multiple should send as an array. Instead it is sending as one concatenated value. Therefore, I tried to format the one value in such a way that I could split it into an array, but then Informix will not execute the prepare statement if I send the sql other than the first element in "my" array.
|
![]() |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
|
|
All times are GMT. The time now is 11:48 PM.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
Ad Management by RedTyger





Linear Mode
