RE: Create / modify Access table in CF5
I took it as if though he wanted to do it dynamically. If it's design view, just set the fields length to 0. It will stick from there... it just wont stick with an 'alter' or 'create' query. Not a simple one anyway. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 1:23 PM To: CF-Talk Subject: Re: Create / modify Access table in CF5 > Unfortunately, I can't find any references to zero-length fields... > > Rick Not sure if I missed something, but the "allow zero-length" is shown below the column list when in design view of a table and when a column in the list is selected. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Create / modify Access table in CF5
> Unfortunately, I can't find any references to zero-length fields... > > Rick Not sure if I missed something, but the "allow zero-length" is shown below the column list when in design view of a table and when a column in the list is selected. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233941 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Create / modify Access table in CF5
You'll just have to play around with the syntax http://support.microsoft.com/default.aspx?scid=kb;en-us;180841 you could try the NULL keyword This page says you can use "NOT NULL" so you can probably use "NULL" too.. which is probably the default. Unfortunately, I can't find any references to zero-length fields... Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create / modify Access table in CF5
I believe the lowest number your going to get is 1. You could however write a custom expression for the field to validate it if it's len() is 0. Just a thought. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 8:41 AM To: CF-Talk Subject: Create / modify Access table in CF5 I have searched my archives and found a file called createtable.cfm That allows me to create a table in an existing Access datasource, but it does not allow me to define a field to allow zero length. Does anyone have a file you could share to allow me to do this? Terry Troxel ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54