Conversion error from string

chinni_77

Hello every body,
I'm really sorry as i posted the wrong code.I edited my post, so, pls tell me what is the error now.

I get the error "Conversion error from string" when i try to leave a check box empty and other being checked after i hit the insert button.

How can i avoid this error?

Here is the code involved with my two check boxes:

if ($enrolment==NULL) $enrolment=0;
if ($ciphering==NULL) $ciphering=0;

<INPUT type=checkbox name="enrolment[<?$rbscount?>]" <? if ($enrolment==1)echo "checked";?>>
<INPUT type=checkbox name="ciphering[<?$rbscount?>]" <? if ($ciphering==1)echo "checked";?>>

ps:rbscount is nothing but to get the count, i.e how many to add to the table.

Thanks in advance

stuartc1

try without stating the chechbox value as 1, like this:

if thats not working try without using the $counter variable, like this:

HTH

swallace

<INPUT type=checkbox name="enrolment[<?=$counter?>]" value="1"<? if ($enrolment==1)echo "checked";?>>

Do you need to say which $enrolment is checked? i.e. if ($enrolment[$counter]==1...)

This could be where the error is coming from but I'd have to test it out myself...

stuartc1

unchecked boxes will not get passed. the actual values are not important, if it has been passed then it was checked.

Weedpacket

Originally posted by stuartc1
unchecked boxes will not get passed. the actual values are not important, if it has been passed then it was checked.

Exactly; so you just need to see if the variable isset.

chinni_77

sorry, there was mis-typing of my code.I just edited my first post.
could somebody pls point out the error now.

Thanks

Weedpacket

The line numbers in the error message might give a hint if they refer to:

<INPUT type=checkbox name="enrolment[<?$rbscount?>]" <? if ($enrolment==1)echo "checked";?>>

You're definitely missing something there.

chinni_77

It shows the error after my insert statement.

Case1:

The follwing error occurs when one or both the checkboxes are checked.

Error executing the insert statement.
Interbase Reported:conversion error from string "on"

Case2:
The follwing error occurs when both the checkboxes are un-checked.

Error executing the insert statement.
Interbase Reported:conversion error from string ""

hmm....I'm getting confused

Weedpacket

Well, those errors, as they say, are coming from the database. It sounds like you're trying to store a string value (i.e. "on" in the one case and "" in the other) in a field that does not take string values. Presumably, Interbase doesn't know what sort of number "on" is supposed to be.

Can't help you much with that; partly since I haven't seen any insert statements.

I have seen you're missing an = from your [<?=$rbscount?>] - one of the perils of "syncopated PHP tags".

chinni_77

OK, here is the part of my code.The curly braces which are engaged with loops are properly ended at appropriate places.
This is only a part of my code.Only the check boxes troubles me.

Hope somebody can fix my problem.

Thanks for all your support!

if ($frm_save == 1)
{
  for ($i = 0; $i < $rbs_add; $i ++)
  {
if ($enrolment==NULL) $enrolment=0;
if ($ciphering==NULL) $ciphering=0;
$insert_sql = "Insert into TBL_RBS(RBS_TFTPFILENAME, RBS_TFTPSERVERIPADDRESS, RBS_RFPI, RBS_IPADDRESS, RBS_ENROLMENT, RBS_CIPHERING, RBS_MACADDRESS, RBS_SUBNETMASK, RBS_ROUTERIP) values ('$tftp_file[$i]','$tftp_server[$i]','$rfpi[$i]','$ip_address[$i]','$enrolment[$i]','$ciphering[$i]','$mac_address[$i]','$subnet_mask[$i]','$router_ip[$i]')";
$insert_results = ibase_query($connection, $insert_sql);
if (!$insert_results) {
echo "Error executing the insert statement. <br />Interbase Reported:".ibase_errmsg()." <br/>".
"SQL=$insert_sql<br />\n";

}
ibase_commit();
}
}

<?
//checks for array length
for ($i = 0; $i < $rbscount; $i ++)
 {
 $num = $i;
 if (strlen($num) == "1") $num = "0" . $num;
 ?>

<INPUT type=checkbox name="enrolment[<?$rbscount?>]" <? if ($enrolment==1)echo "checked";?>>
<INPUT type=checkbox name="ciphering[<?$rbscount?>]" <? if ($ciphering==1)echo "checked";?>>

Weedpacket

Originally posted by chinni_77

<INPUT type=checkbox name="enrolment[<?$rbscount?>]" <? if ($enrolment==1)echo "checked";?>>
<INPUT type=checkbox name="ciphering[<?$rbscount?>]" <? if ($ciphering==1)echo "checked";?>>

[/B]

Did you read my last post about these?

chinni_77

HI weed,

yep. i've read your previous posts.

After i changing all my form fields into [<?=$rbscount?>], I observed something really strange.
when i tried to insert the fileds, I noticed empty values are being passed.

I echoed my sql st, it looks something like this:

SQL=Insert into TBL_RBS(RBS_TFTPFILENAME, RBS_TFTPSERVERIPADDRESS, RBS_RFPI, RBS_IPADDRESS, RBS_ENROLMENT, RBS_CIPHERING, RBS_MACADDRESS, RBS_SUBNETMASK, RBS_ROUTERIP) values ('','','','','','','','','')

Any ideas?

Thank you

Weedpacket

Yes. Are you getting your form's values from out of the $_POST[] array like you should? I.e., is there some code you haven't shown me up the top which goes

$ciphering = $_POST['ciphering'];
etc.

chinni_77

hmm...not really though.

Shall i post my entire code.I think then, you would need few seconds to find the error:-/

Weedpacket

Well, as stated in the manual (repeatedly), if register_globals is turned off (and it is by default), then POSTed form data will be found in the $_POST[] array (or $HTTP_POST_VARS[] in versions of PHP prior to 4.1). Just using the form fields' names as variables won't work - they'll all just be empty.

Don't bother posting the entire code solely for my benefit - my eyes generally glaze over when I see such a thing.