Re: DBI gives out wrong data

I have found that some versions of mySQL are sensitive to spaces in the value chunk. Try removing the spaces around the fieldnames.

Instead of:

dbtable.field, dbtable.field2, ...
[download]

use:

dbtable.field,dbtable.field2,...
[download]

Comment on Re: DBI gives out wrong data Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI gives out wrong data by robscov (Initiate) on Jun 27, 2005 at 13:08 UTC
Hi, Thanks for your responses. trace gives me the following info (just one row posted). Removing the spaces didn't correct the error. I am baffled by this! Thanks again, Rob -> fetchrow_hashref for DBD::mysql::st (DBI::st=HASH(0xa039770)~0x +a03f904) 1 -> FETCH for DBD::mysql::st (DBI::st=HASH(0xa03f904)~INNER 'NAME') -> dbd_st_FETCH_attrib for 0a02920c, key NAME 1 <- FETCH= [ 'i_preference_desc' 'name' 'range_value' 'value' 'def_ +value' ] at voicemail_options.html line 95 via /usr/local/lib/perl5/s +ite_perl/5.8.2/HTML/Mason/C omponent.pm line 134 1 -> fetch for DBD::mysql::st (DBI::st=HASH(0xa03f904)~INNER) -> dbd_st_fetch for 0a02920c, chopblanks 0 Storing row 0 (10) in 0a02d7ac Storing row 1 (ext_email_action) in 0a02eb44 Storing row 2 (none, forward, notify, copy) in 0a02ebb0 Storing row 3 (no) in 0a02d5c0 Storing row 4 (none) in 0a034e44 <- dbd_st_fetch, 5 cols 1 <- fetch= [ '10' 'ext_email_action' 'none, forward, notify, copy' +'no' 'none' ] row11 at voicemail_options.html line 95 via /usr/local/ +lib/perl5/site_perl/5.8.2/H TML/Mason/Component.pm line 134 <- fetchrow_hashref= HASH(0xa03c740)5keys row11 at voicemail_optio +ns.html line 95 via /usr/local/lib/perl5/site_perl/5.8.2/HTML/Mason/C +omponent.pm line 134 [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: DBI gives out wrong data
by robscov (Initiate) on Jun 27, 2005 at 13:08 UTC

    -> fetchrow_hashref for DBD::mysql::st (DBI::st=HASH(0xa039770)~0x
+a03f904)
1   -> FETCH for DBD::mysql::st (DBI::st=HASH(0xa03f904)~INNER 'NAME')
    -> dbd_st_FETCH_attrib for 0a02920c, key NAME
1   <- FETCH= [ 'i_preference_desc' 'name' 'range_value' 'value' 'def_
+value' ] at voicemail_options.html line 95 via /usr/local/lib/perl5/s
+ite_perl/5.8.2/HTML/Mason/C
omponent.pm line 134
1   -> fetch for DBD::mysql::st (DBI::st=HASH(0xa03f904)~INNER)
    -> dbd_st_fetch for 0a02920c, chopblanks 0
      Storing row 0 (10) in 0a02d7ac
      Storing row 1 (ext_email_action) in 0a02eb44
      Storing row 2 (none, forward, notify, copy) in 0a02ebb0
      Storing row 3 (no) in 0a02d5c0
      Storing row 4 (none) in 0a034e44
    <- dbd_st_fetch, 5 cols
1   <- fetch= [ '10' 'ext_email_action' 'none, forward, notify, copy' 
+'no' 'none' ] row11 at voicemail_options.html line 95 via /usr/local/
+lib/perl5/site_perl/5.8.2/H
TML/Mason/Component.pm line 134
    <- fetchrow_hashref= HASH(0xa03c740)5keys row11 at voicemail_optio
+ns.html line 95 via /usr/local/lib/perl5/site_perl/5.8.2/HTML/Mason/C
+omponent.pm line 134
[download]

[reply]
[d/l]