Go Back   iTrader Forums » iTrader Chat » General Chit Chat » Programming PHP | PERL | ASP| ColdFusion| C++

Programming PHP | PERL | ASP| ColdFusion| C++ Chat with other forum members about programming.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 14th November 2007, 05:12 PM
Junior Member
 
Join Date: Nov 2007
Posts: 1
Credits: 0
Default Select Multiple with Perl CGI and HTML template?

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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



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
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
Ad Management by RedTyger


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72