HELP!...

[vanillapod]

Okay so i've been using Ultradev to do all of the connections / recordsets anyway i've done a load of pages and have just noticed that in certain places it has written code as below:

MM_editTable = "c:\Inetpub\

http://wwwroot\db\DBName.TableName"

Anyone know if i can change this so that it uses servmap or something? as the path may change! might not be c:\inetpub\

http://wwwroot

etc.

Cheers in advance

 

[schase]

Hi Vanilla,

Sure, easy fix - The Find and Replace tool that is in UD4 is a fantastic item. You can open your site - goto edit, find and replace - select folder - browse to your website.

select source code in find box - paste the exact text like you did above.

In the replace box - alter the text to what you want.

Hit find all - verify the results - when satisfied - hit replace all.

But word of caution - be as specific as you can and still be able to get items from every page.


Now that fixes that, but.

If you created everything in UD4, why are your pages not using an include file to connect to the database?

that would give you only one file to change for all of your connections if it does change.

 

[vanillapod]

Cheers for the reply schase
Thats just it, I am using an include file as i was trying to avoid exactly this situation! I thought everything was turning out really nicely and then i realise this is going on the first few lines of a typical page are listed below:

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include file=&quot;Connections/Dbase.asp&quot; -->
<!--#include file=&quot;Connections/Right.asp&quot; -->
<%
set Clients = Server.CreateObject(&quot;ADODB.Recordset&quot
Clients.ActiveConnection = MM_Dbase_STRING
Clients.Source = &quot;SELECT ClientName, ClientCode FROM c:\Inetpub\

http://wwwroot\db\Dbase.Clients

ORDER BY ClientName&quot;
Clients.CursorType = 0
Clients.CursorLocation = 2
Clients.LockType = 3
Clients.Open()
Clients_numRows = 0
%>

I've started deleting the string c:\Inetpub\

http://wwwroot\

as my asp's are in the

http://wwwroot

folder and it seems to be working so far but why did this happen in the first place?!

 

[schase]

Ok do the find and replace from that c:\inetpub\

http://wwwroot\db\dbase.clients

to the table name. (I take it clients?

Is this web folder on a server of your own? or is it remotly hosted?

 

[vanillapod]

Its gonna be on an a web server....

 

[schase]

Hey Vanilla,

You should be able to safely do the find and replace on the c:\inetpub\

http://wwwroot

part. That particuliar one is pretty strange. I have seen it save and upload as file\\c:\ etc, etc, etc.

The direct path is cool - but unless you need to configure your connection script - or some cgi that may require direct path - it isn't necessary.

&quot;If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for &quot;TipMaster Of The Week&quot;. You don't need to be the one who asked the question to vote&quot;

Stuart