You have chosen to sponsor your bid up to a maximum amount of .
The web sites treasureslittleflowershop.com.au and gilbertaust.com.au have a few bugs that need fixing. The server runs Cold Fusion 8.
1. Each web site uses an excel spreadsheet which is imported into a access database that is linked to the web site.
We update the spreadsheet and run a CFM file which updates the database. However, since upgrade the web server to CF8 the import routine file "Catastrophically". That is the data is purged from the DB but the new data is not added. See error below. Please note this file links to our LIVE SITE so I can not afford anyone testing it. So I have removed the file until I can discuss the fix with the devoloper
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
The error occurred in C:\webspace\TreasureLittleFlowerShopcomau\store\Import_Swc_TLFS.cfm: line 114
115 : SELECT * from WHERE access = 'Release'
SQL SELECT * from WHERE access = 'Release'
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows NT 6.1; rv:24.0) Gecko/20100101 Firefox/24.0
Remote Address 192.168.1.1
Date/Time 09-Oct-13 11:46 AM
at cfImport_Swc_TLFS2ecfm1632845744.runPage(C:\webspace\TreasureLittleFlowerShopcomau\store\Import_Swc_TLFS.cfm:114) at cfImport_Swc_TLFS2ecfm1632845744.runPage(C:\webspace\TreasureLittleFlowerShopcomau\store\Import_Swc_TLFS.cfm:114)