Hello Guys: I am having a hard time with this query, as it relates to Access. I have a database with a table called tblPhotos. One column in this table is...
Are you darn sure the path will not have any variations of the word "locations"? If so, you can rs("path") = Replace(rs("path"),"/Locations/","/") ... ...
Chris: Thank you, but I would prefer to make the change at the database level and not on the .asp page. Although I could write an ASP page doing exactly as you...
Use an update query like so:- Update [tablename] set [path] = Replace([path],"/Locations/","/") where... Dan ... From: active-server-pages@yahoogroups.com ...
OOOOOOOHHHHHHH....... Chris was talking using the Replace in the SQL Statement. I missed that part :-( I was VERY confused. Thanks to both of you for your...
Are you running Access locally against the database? Just open the table in Access and use search/replace to do a normal global change. You can limit the...
Hello all, first post here.... I'm hoping it's possible to write a function that will let a client download their Access db, via an ASP page. The db is stored...
Can someone help me on this? I am working on a project that requires uploading one or more documents to an SQL database table. Does someone know where can I...
Thanks, probably didn't make myself clear there, but the db is outside the webroot, as in above it. E.g: / somewhere / db / some.mdb / somewhere / siteroot /...
Hi All, As I am moving to ASP.Net 2.0 I would like to use the new features available like LoginView, directory security as much as possible. But it seems to...
You could use the ADO Stream component to do this. If you google something like "Download file ADODB.Stream" you should get a good few pointers. Dan ... From:...
Anyone know a good reference to XML and processing it with VBS into a database? I can download data that looks like this, and I would like to process it, but...
Hello everyone, I want to learn ASP. so please suggest me a good book which is for beginners and which cover all the important topics in detail. i have sams...
Have you worked through that one? It is an adequate book for beginners. Once you've mastered everything in that, then Google for specific questions. Regards,...
I am not sure if you want .Net, or plain .ASP, but after the 24 hour book: pick up ASP.Net unleashed by Sams Publishing. I had the 24 Hour book for .Net and...
Hi Andy, thanks for the reply. I am looking for a plain ASP book not for .net. Because in my company we use ASP right now. Is there any book from Microsoft...
I'm a big fan of Beginning Active Server Pages 3.0 from Wrox Publishing. I don't know the if the book is still in print, but you could probably find it ...
It's still in print in the UK and available on Amazon.co.uk. And I agree... A good all-rounder of a book in good old Wrox style (i.e. before they changed the...
there is also the sams 'ecommerce programming with asp' text. ... -- http://www.londonmet.ac.uk [Non-text portions of this message have been removed]...
dear all, I have a problem when i create connection database mysql from asp, i get a error message like this : Microsoft Cursor Engine (0x80040E21) ...
Thanks Dan and Ray for reply. fortunately i got the ASP book from Wrox. but that is Professional ASP 3.0.so should i start reading that directly or first look...
Good morning group. I am looking for a free, RELIABLE RSS feed. I made an app that creates a small list of news links based on an RSS feed. The code works...
Doesn't places like CNN provide this? ________________________________ From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com]...