Thanks for that, I'll give it a go.
I'm sure I'll be back soon, hope that's ok.
Stevee
Last Activity: Feb 19 '08, 08:23 PM
Joined: Sep 13 '07
Location:
-
Thanks for that, trying to find the function that should pass the PUBID value, I have checked the paths and they all seem fine, any ideas?
Steve....Leave a comment:
-
Thanks for tonight, hope to catch you tomorrow.
Stevee...Leave a comment:
-
Hate being stoopid but why doesn't it work when I now take out the 2 lines you gave me earlier:
Response.Write( "[" & strSQL & "]")
Response.End
Stevee.Leave a comment:
-
All it's actually doing is printing the 4th line:
strSQL = "SELECT * FROM tblPublications WHERE PubID = " & PUBID
SteveeLeave a comment:
-
When I take out the:
Response.Write( "[" & strSQL & "]")
Response.End
you had me put in earlier then I get:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'PubID ='.
/asp/functions.asp, line 18
When I put it in I get the
Included file - top.asp and then start...Leave a comment:
-
I will give it a go see what happens, and let you know. I was assured that all these asp scripts I have inherited worked as were, and was told it was merely a case of changing paths to the database, but it looks like I've recieved a bag of worms!
Thanks for all your help, hope you'll be around a while longer.
Stevee...Leave a comment:
-
I'm sorry, but what has changed?
It now doesn't get an error it goes further into it but isn't actually finding the database name (I think):
[SELECT * FROM tblPublications WHERE PubID = ]
is written on the browser window, but now the #include file - top.asp (slightly different than the header.asp) is showing.Leave a comment:
-
Or do I have to remove the line breaks?Leave a comment:
-
So altogether:
Function SetCurrentPub(P ubID)
OpenDB
Set rs=Server.Creat eObject("ADODB. Recordset")
'strSQL = "SELECT * FROM tblPublications WHERE PubID = " & PUBID
strSQL = "SELECT * FROM tblPublications WHERE PubID = " & PUBID
Response.Write( "[" & strSQL & "]")
Rresponse.End
rs.Open strSQL, conn
...Leave a comment:
-
So like this:
Function SetCurrentPub(P ubID)
OpenDB
Set rs=Server.Creat eObject("ADODB. Recordset")
'strSQL = "SELECT * FROM tblPublications WHERE PubID = " & PUBID
strSQL = "SELECT * FROM tblPublications WHERE PubID = " & PUBID
Response.Write( "[" & strSQL & "]")
Rresponse.End
rs.Open strSQL, conn
...Leave a comment:
-
Where in the code, right at the begining before everything else?...Leave a comment:
-
Well I have to assume it's an integer, it's actually a database table name, it now gives an:
Unterminated string constant
/asp/functions.asp, line 13, column 61
Columns throw me a little.
Stevee....Leave a comment:
-
Thanks, I'll try them both, will advise. :-)Leave a comment:
-
missing operator
Hi, assistance would be appreciated, I have inherited a database and a bunch of .asp scripts, I have amended the database and have managed to get to view etc on line using aspmaker, GREAT (I thought). The asp's are all used to run on a different server I am now using a PC, WIndows, XP Pro through IIS. Having not used asp before I thought I'd have a quick look and see.
The problem I am getting is:
Error Type:
Microsoft... -
Thankyou, I had to amend slightly (one * 1) + etc but this works great:
[CODE=javascript]
<script type="text/javascript">
function startCalc()
{
one = document.getEle mentById("info" ).value;
two = document.getEle mentById("info1 ").value;
three = document.getEle mentById("info2 ").value;
total = (one * 1) + (two * 1) + (three * 1);
total...Leave a comment:
-
Sorry, I did no better than a "D" in GCE Math some 31 years ago, and that lot just wasted me. can you assist with the toFix please...Leave a comment:
-
Gotcha, thankyou.
But why when it adds up 2 of the combo numbers ie 19.52 + 100 it equals 119.52
However when I add 3 of the combo numbers ie 19.52 + 100 + 99 it equals 218.51999999999 998...Leave a comment:
-
Right, I have tried that again and the TotalValue gives me the NaN
[CODE=javascript]
<script type="text/javascript">
function startCalc()
{
one = parseFloat(docu ment.getElement ById("info").va lue);
two = parseFloat(docu ment.getElement ById("info1").v alue);
three = parseFloat(docu ment.getElement ById("info2").v alue);
document.getEle mentById("Total Value").innerHT ML...Leave a comment:
-
[code=javascript]
<script type="text/javascript">
function startCalc()
{
one = parseFloat(myli st=document.get ElementById("in fo").value);
two = parseFloat(myli st=document.get ElementById("in fo1").value);
three = parseFloat(myli st=document.get ElementById("in fo2").value);
document.getEle mentById("Total Value").innerHT ML = parseFloat(one + two + three);...Leave a comment:
No activity results to display
Leave a comment: