Closed

Web Site Bug Fixes

This project received 10 bids from talented freelancers with an average bid price of $34 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$10 - $30 USD
Total Bids
10
Project Description

The web sites [url removed, login to view] and [url removed, login to view] 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\[url removed, login to view]: 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 [url removed, login to view](C:\webspace\TreasureLittleFlowerShopcomau\store\[url removed, login to view]) at [url removed, login to view](C:\webspace\TreasureLittleFlowerShopcomau\store\[url removed, login to view])

2.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online