Help needed .... Access db

Help needed .... Access db - InterDev

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BobTheBowler - 09 May 2007 06:32 GMT

Hi

I wrote a website about 8 years ago - http://www.ProBowkUK.co.uk
It has an Access database of web links and a number of pages that
show the different categories.
ex: http://www.ProBowlUK.co.uk/pblOrgs.asp

I may need to make a lot of changes to the website.

Although these asp pages are working fine online, whenever I try to
run them in my MS InterDev v6.0 (Microsoft's "Dreamweaver")
the listings do not show up and an error is reported.

here is the code ....

><%
>    urlPath = "c:/domains/ProBowlUK.co.uk/db/pbLinks.mdb"
>    mapFilePath = Server.MapPath("db/pbLinks.mdb")
>    fileDSN = " DBQ=" & mapFilePath
>    urlDSN = " DBQ=" & urlPath
>
>    Set myConn = Server.CreateObject("ADODB.Connection")
>    myConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & urlDSN & ";"
>
>    sql_Query = "SELECT * FROM pblLinks WHERE pblCat='Org' ORDER BY pblName"
>    set rs = myConn.Execute(sql_Query)
>    WHILE NOT rs.EOF
>%>
>    <tr>
>        <td class="b" />
>        <td class="l"> <a href="#" onClick="fOpenLinksWindow('<%=rs("pblLink")%>');" > <%=rs("pblName")%> </a> </td>
>        <td class="b" />
>        <td class="d"> <%=rs("pblDesc")%> </td>
>        <td class="b" />
>    </tr>
>
><%
>    rs.MoveNext
>    WEND
>%>

This is what is appearing in the first field ... ');"

obviously it involves the quotes, but why would it work online and
not on InterDev ?

as I said, did this 8 years ago and have forgotten how the DB was
set up

best regards

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Bob Barrows [MVP] - 09 May 2007 10:22 GMT

> Hi
>
[quoted text clipped - 8 lines]
> run them in my MS InterDev v6.0 (Microsoft's "Dreamweaver")
> the listings do not show up and an error is reported.

If you're talking about the Quick Preview feature in Interdev, you need to
read the dialog box a little more closely: server-side code is not run when
switching to Quick Preview: only client-side.

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

BobTheBowler - 09 May 2007 10:37 GMT

>If you're talking about the Quick Preview feature in Interdev, you need to
>read the dialog box a little more closely: server-side code is not run when
>switching to Quick Preview: only client-side.

ah ...

Is there any way to set it up so that I can test it "local" (on the
dev PC) ?

Signature

Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Bob Barrows [MVP] - 09 May 2007 11:48 GMT

>> If you're talking about the Quick Preview feature in Interdev, you
>> need to read the dialog box a little more closely: server-side code
[quoted text clipped - 4 lines]
> Is there any way to set it up so that I can test it "local" (on the
> dev PC) ?

Debugging is one of the main features that draw people to use Interdev.
Instead of switching to Quick View, take a look at the Debug menu and take a
look in online help about debugging.

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

Webmaster Forum / ASP / Database Access / May 2007

Help needed .... Access db - InterDev