Is this how I should do:
<input type="checkbox" value=<% =rsPro("ProdNum") %> name="productid" <% if inStr(productid,"-"&rsPro("ProdNum")&"-") then response.write ("Checked") %>><% =rsPro("ProdName") %>
The code doesn't check the boxes as if it doesn't see any match.
to save it in "-1-2-3-4-"???
thing is... when a software is added into a database, it can be the software for more than 1 product. Therefore, I had products' checkboxes so that user can check to the boxes that applied to the software added. After saved, the column in table will display, for...
Hello all,
I have a sql:
<input type="checkbox" value=<% =rsPro("ProdNum") %> name="productid" <% if inStr(productid,trim(rsPro("ProdNum"))) then response.write ("Checked") %>><% =rsPro("ProdName") %>
my intension is to get product name box checked if the product number matches with one of the...
Hello all,
i got this ERROR: "unterminated string constant" from a page and I pretty sure that comes from a Javascript code using for a pulldown rollover links. The links were pulling down fine until this morning, out of nowhere, they all dead, no pulling down anymore. An addition to that, I...
Hello all,
I want to create a text link in a Flash MX banner that, when clicked, will open another html page.
I tried
ButtonName.onrelease
getURL(www.hotmail.com, _blank);
But no luck! :-)
:-)
AHA!!!
Thank you for reminding me to link the dbconn file to this page.
I thought I did on the main page because this page is a portion of the larger main page. But I was wrong.
Thank you guys. :-)
Hello all,
I really don't know where this error is about
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/includes/subnav/products_subnav.asp, line 3
My first few line of code are:
<%
sqlHots = "SELECT ShortName, ProductID, ManuID, ProdTypeID FROM tblProducts WHERE New = 1"...
Hello all,
I really don't know where this error is about
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/includes/subnav/products_subnav.asp, line 3
My first few line of code are:
<%
sqlHots = "SELECT ShortName, ProductID, ManuID, ProdTypeID FROM tblProducts WHERE New = '1'"...
This is where I located Option Explicit in
"dbconn.asp":
<% Option Explicit %>
<%
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={SQL Server};" &_
"Server=xxx;" &_
"Database=xxx;" &_
"Network=DBMSSOCN;" &_
"Uid=xxx;" &_
"Pwd=xxx;"
%>
And everytime...
This is a portion of the whole page where the ERROR pointing to:
<%
Dim rs
Dim MSQL1
MSQL1 = "SELECT * FROM tblManufacturers"
Set rs = objConn.Execute(MSQL1)
Dim ProdTypeSQL, rs2
ProdTypeSQL = "SELECT * FROM tblProductType"
Set rs2 = objConn.Execute(ProdTypeSQL)
Dim sql1, rs1...
This page is a include file that was added to my another page. The main is already contain the Option Explicit.
However, I did add the Option Explicit to the top of the page and got another ERROR:
Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement...
:-) You're right, this is a very funny error.
That ERROR points right at this part:
<%
Dim ManuSQL
Dim rs
ManuSQL = "SELECT * FROM tblManufacturers"
Set rs = objConn.Execute(ManuSQL)
Dim ProdTypeSQL, rs2
ProdTypeSQL = "SELECT * FROM tblProductType"
Set rs2 =...
Thank you onpnt,
How about this ERROR:
Microsoft VBScript compilation (0x800A0411)
Name redefined
/includes/subnav/printers_subnav.asp, line 2, column 4
I'm keep getting ERRORs since I start adding Option Explicit :-)
Good afternoon,
I start over again learning ASP the right way.
While adding
<%@ Language=VBScript %>
<% Option Explicit %>
I got an ERROR:
Active Server Pages, ASP 0140 (0x80004005)
The @ command must be the first command within the Active Server Page.
/includes/htmltop.asp, line 1
I look...
UPDATE, UPDATE!!!
I found where the problem that is located in the include page on way top that link to "function.asp" which will then open "dbconn.asp".
It's working now. But I believe that I should start learning to apply what I have learned in all of your help today to make my pages...
You're right Tawn
I haven't declared Option Explicit, ObjConn, nor Dim'ing my variable lately.
In my every page has <--! include ... --> that link to the page "dbconn.asp" and some other pages as well, which also like you said causing even more complication to my code.
My question to you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.