Link to home
Start Free TrialLog in
Avatar of rstrang
rstrang

asked on

Undefined function error when creating database results page to MS Access DB from Front Page with Replace() function

I'm trying to strip the dashes out of an ISBN string field for my book database for use in my web page. Here's the SQL query as created by MS Access (and subsequently modifed by me :-)

SELECT Editions.ID, Editions.ISBN, Replace([Editions].[ISBN],"-","") AS CleanISBN
FROM Editions;

The query works fine in Access, but I get the following error when I try to create a database results region in FrontPage 2000:

Server error: Unable to retrieve schema information from the record source 'Web: Edition Detail foo' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/library.mdb'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'Replace' in expression.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)


I've read in various places that not all functions available in Access are supported by the ODBC driver, however my research seems to indicate that Replace() is an ODBC 1.0 function, and I'm using drivers with versions 4.0+

So I'd like to know how to tell the ODBC driver to smarten up, or how to remove the dashes after the data has been retrieved into the web page. I'm not adverse to using JavaScript or something like that, but I'd need a detailed answer, as I'm not familiar with JavaScript or other client side scripting options.

Thanks,!
ASKER CERTIFIED SOLUTION
Avatar of hhammash
hhammash

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rstrang
rstrang

ASKER

Wow! Fast and easy. How come I didn't find the Spooky Diet when I was doing my search for Front Page web resources?

Thanks a lot!

Richard
You are welcome

hhammash