Web Site Bug Fixes

CLOSED
Bids
10
Avg Bid (USD)
$34
Project Budget (USD)
$10 - $30

Project Description:
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

112 :
113 :
114 :
115 : SELECT * from WHERE access = 'Release'
116 :

SQLSTATE 42000
SQL SELECT * from WHERE access = 'Release'
VENDORERRORCODE -3506
DATASOURCE GilbertAust2K_XLS
Resources:

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
Referrer
Date/Time 09-Oct-13 11:46 AM
Stack Trace
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)

2.

Skills required:
Cold Fusion, HTML
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 35
in 1 days
$ 30
in 1 days
$ 35
in 0 days
$ 31
in 0 days
Hire thecoldfusioner
$ 45
in 1 days
$ 50
in 1 days
$ 23
in 1 days
Hire nuciferainfotech
$ 30
in 3 days
$ 25
in 1 days
Hire sbabaran
$ 35
in 3 days