2. PHPRunner General questions
  3. Issue with: zero-length string
This topic is locked

Issue with: zero-length string

 		7/29/2008 11:48:43
PHPRunner General questions
D
 dancerdog3 author

I am using a MS Access Db and the issue I have it that every field is acting like it is required. If I try to enter a record that has nothing typed in the input field, I get this error:

odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Field 'issue.group' cannot be a zero-length string., SQL state S1000 in SQLExecDirect
The field name is 'issue.group' and it is not a required field.
How do I get around this and allow the adding or editing of a record that has a field with no information?
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=9129&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
J
 		Jane 7/30/2008

Hi,
please make sure these fields aren't set up as required in the database directly.
D
 		dancerdog3 author 7/30/2008

The database does not require these fields.
But, using the PHPRunner generated code, I cannot enter or edit records that have any field that does not have something in it. I can work around this by setting a default value for everything to a period, '.', but this seems odd that I cannot enter a record that has fields with no values.
Thanks
J
 		Jane 7/31/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
D
 		dancerdog3 author 8/24/2008

I created a demo and sent the info to support. Now I am waiting to hear from them.
Does anybody else have the problem of not being able to enter a record with a null value for any of the items?

I am using MS Access for the db and Vista with WAMP installed.
Thanks <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=32452&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
D
 		dancerdog3 author 9/8/2008

Here is the solution provided by Sergey:
------------------
You need to open "issue" table in MS Access in design mode and check off "Allow zero length values" for "group" field. This will allow empty values in "group" field.
-----------------
This worked and now all is good.
Thanks! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=32827&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />