Express - CFQUERY -> DELETE

[BowlerBob]

Could I trouble you with this ? ...

...
...
<CFelseif URL.op IS "d">
    <!---Delete processing --->
    <CFquery NAME="qDelete" DATASOURCE="leancfe" >
         DELETE FROM Guestbook
         WHERE GuestBook_ID = #URL.gid# 
    </CFquery>
<CFelse>
    <!---Unknown processing operation --->
    Error, invalid processing type!
</CFif>

Error Diagnostic Information

ODBC Error Code = ()
Unsupported ODBC data source leancfe for ColdFusion Express. The data source may not exist or no driver is specified for the data source.

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (90:2) to (90:47).

Date/Time: 12/28/08 17:04:25
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5
Remote Address: 127.0.0.1
HTTP Referer:

http://localhost/tt380/GuestMaint_ListURL.cfm

Template: c:\inetpub\

http://wwwroot\tt380\GuestMaint.cfm

Query String: op=d&gid=25

 

[LyndonOHRC]

Is your database open on your desktop?

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[LyndonOHRC]

I just spotted it. You misspelled the datasource: leancfe should be learncfe

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[BowlerBob]

Oh, woe is me !
Deaf as a post, and now blind as a bat !