NuSphere Forums Forum Index
NuSphere Forums
Reply to topic
[resolved] 5.2 DB-Form wizard


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote
First, congrats on 5.2! I'm thrilled to see code folding has be extended to all code blocks!

Very Happy

I thought I try the DB-Form Wizard but I have run into several problem:

When I try to edit a record I get "Field is not a valid integer" but all entries are integers! Same happens on insert.

I also notice the the sort feature has no support for sorting descending. This is a major drawback. Clicking on the field button when it is already sorted by the field should reverse the sort. Has anybody implemented this?

I sure would love to make use of this tool! Can you help me?

Thanks!
Barry'
View user's profileFind all posts by bchertovSend private messageVisit poster's website
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
could you please submit db structure there and s/shots of the settings in DB Wizard?

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote
dmitri wrote:
could you please submit db structure there and s/shots of the settings in DB Wizard?


CREATE TABLE `wacco_digest` (
`digestid` int(10) unsigned NOT NULL auto_increment,
`dateline` int(10) unsigned NOT NULL default '0',
`numemailsent` int(10) unsigned NOT NULL default '0',
`elapsetime` int(10) unsigned NOT NULL default '0',
`startchar` varchar(20) NOT NULL default '',
`endchar` varchar(40) NOT NULL default '',
`abortflag` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`digestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1739 ;


Images coming shortly
View user's profileFind all posts by bchertovSend private messageVisit poster's website


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote




And why can't I deselect any of the fields in the wizard??

Thanks!
View user's profileFind all posts by bchertovSend private messageVisit poster's website


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote
P.S. Note that digestid is not displayed, but it does have a valid value (I just clicked Update and Save to bring up the error screen above).
View user's profileFind all posts by bchertovSend private messageVisit poster's website
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
you may want to correct one line in CheckNumeric() function:

var el = theForm.elements[arguments[i]];
=>
var el = theForm.elements[arguments[i] - 1];

Quote:
And why can't I deselect any of the fields in the wizard??

because they are defined as not null in your SQL and therefore they all are required.

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote
dmitri wrote:
you may want to correct one line in CheckNumeric() function:

var el = theForm.elements[arguments[i]];
=>
var el = theForm.elements[arguments[i] - 1];

Thanks! I notice this is in the generated code. How do i fix it so that it is generated correctly?

Quote:
because they are defined as not null in your SQL and therefore they all are required.
Gotcha! THanks!
View user's profileFind all posts by bchertovSend private messageVisit poster's website
Site Admin

Joined: 13 Jul 2003
Posts: 8344
Reply with quote
see corresponding tempate in phped's plugin subdirectory

_________________
The PHP IDE team
View user's profileFind all posts by dmitriSend private messageVisit poster's website


Joined: 29 Mar 2006
Posts: 57
Location: Sonoma County, CA USA
Reply with quote
dmitri wrote:
see corresponding tempate in phped's plugin subdirectory

I was looking for a little more help. What do you think I am, a programmer? Smile

Fixed. Thanks! Be sure to include it in your next service pack!
View user's profileFind all posts by bchertovSend private messageVisit poster's website
[resolved] 5.2 DB-Form wizard
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 5 Hours  
Page 1 of 1  

  
  
 Reply to topic