Closed

Web Site Bug Fixes

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.

Skills: Cold Fusion, HTML

See more: web site problem, web site error, upgrade odbc driver, rv updates, problem fixes, linked stack, in-fusion.com.au, html 5 syntax, html 5 documentation, find devoloper, error fixes, driver select, 192 168.1.1, testing and bug fixing, sql odbc, socket excel, rv, mozilla bug, fixing bug, bug testing, data fixes, socket fix, trace stack, data coldfusion, coldfusion excel

About the Employer:
( 25 reviews ) Williamstown, Australia

Project ID: #5008647

9 freelancers are bidding on average $34 for this job

redevolve

Hi, is it possible to take a look at store\[url removed, login to view] before confirming that I can resolve the issue for you? Thanks.

$35 USD in 1 day
(83 Reviews)
5.9
miftkhar

Dear Sir, I am Adobe certified in advanced ColdFusion and have 9 year of experience. I assure you that your time will not be wasted. Waiting for the reply... Thanks with the best regards Muhammad Iftkhar ----- More

$30 USD in 1 day
(17 Reviews)
5.1
olantran

let me help you. I'm very good at Coldfusion. You can check my reviews. I have 5 years experience in this field

$35 USD in 0 days
(14 Reviews)
4.7
eComOS

Hello tribalworks, I have gone through your outsourced requirement "Web Site Bug Fixes" and have analyzed that I have right credentials (Cold Fusion, HTML) to execute your esteemed project. ===== Why choose me More

$31 USD in 0 days
(22 Reviews)
4.2
thecoldfusioner

Hi, I am a CF Developer for Last 7+years and have worked with all kinds of [url removed, login to view] my Portfolio section and my Work on Riaforge Community Cold-fusion website. Worked with many e-commerce and health domain project More

$45 USD in 1 day
(2 Reviews)
2.7
sbabaran

Hi, Have a nice day! I am interested to take this task as I believe I know how to fix this problem. Just contact me just in case you want me to do the fix on this error. Thank you.

$35 USD in 3 days
(0 Reviews)
0.0
masoodanwar85

I have vast experience with handling coldfusion applications and coldfusion server settings. I can help you on this.

$25 USD in 1 day
(0 Reviews)
0.0
nuciferainfotech

Hi, I am an energetic and self-motivated ColdFusion developer with 4+ years of experience in application development, design and implementation of software solutions using (CFML) Adobe ColdFusion and Railo. Having More

$30 USD in 3 days
(0 Reviews)
0.0
pnjadhav

I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(A More

$50 USD in 1 day
(0 Reviews)
0.0
ianraphael

I'm working with web development since 2004 and have strong knowledge with ColdFusion, Javascript and Databases.

$23 USD in 1 day
(0 Reviews)
0.0