problem porting Justin Anderson's CF_X_Survey to MySql

2009-08-26 Thread cfcom 

Has anyone successfully ported Justin Anderson's CF_X_Survey to MySql - I
haven't been able to get mine to work.
http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetailloc=en
_usextid=1000426

thanks


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325720
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: problem porting Justin Anderson's CF_X_Survey to MySql

2009-08-26 Thread Peter Boughton 

What errors are you getting?

And what is the original database format? 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325723
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: problem porting Justin Anderson's CF_X_Survey to MySql

2009-08-26 Thread cfcom 

Survey.mdb (access 97 file format)
Comments (table)
Commentid = autonumber
Surveyid = number
dateEntered = date/time
username = text
userEmail = text
usersWeb = text
subject = text
comments = memo

Options (table)
OptionId = autonumber
surveyid = number
questionOption = text
votes = number

Schedule (table)
SurveyId = number
Startdate = date/time
Enddate = date/time

Survey (table)
surveyId = autonumber
dateEntered = date/time
question = memo


http://aceligen.com/cfxsurvey/
I am unable to see the results or vote. when I press vote it throws this
error:
Error Occurred While Processing Request
The value '' cannot be converted to a number.





-Original Message-
From: Peter Boughton [mailto:bought...@gmail.com] 
Sent: 2009-08-26 10:55
To: cf-talk
Subject: Re: problem porting Justin Anderson's CF_X_Survey to MySql


What errors are you getting?

And what is the original database format? 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325729
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4