Search results for query: *

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! :-)

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'"...

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...

Hello all, I got a very frustrating ERROR: Microsoft VBScript runtime (0x800A01A8) Object required: '' /includes/subnav/labelsribbons_subnav.asp, line 4 This is my code: <% If request.querystring("Labels") <> "" Then sql = "SELECT * FROM tblRibbons" Set rs = objConn.Execute(sql) End If %>...

Goodmorning all, I'm looking for a simple 2 dropdown linked boxes that work for database. The idea is when I select a choice in 1 box, options for that specific choice will then appear in the second one. Select another option in the first one, different choices will be shown on the second one...

Hi all I have a checkbox and input will save into database in BIT (0, 1) This is a code i use to retrieve data from database: <input type="checkbox" name="pnew" value="<% =pnew %>" <% if (pnew) then response.write ("Checked") %>>NEW? This is what I've been think of: If pnew = True Then pnew...

Hello all, I have a checkbox that's supposed to check if its value is 1 or blank if value is 0 (data was set in BIT in database), this is my code <input type="checkbox" value=<% =rs("New") %> name="new" <% if (rs("New") = 1) then response.write ("Checked") %>> It's not working, could someone...

Hello I want to Trim a comma at the end of a string strProdTid = rs1("ProdTypeID") instr(strProdTid, ",") then arrNums = Split(strProdTid, ", ", -1, 1) strName = "" For Each strOneNum in arrNums sql = "SELECT ProdTypeName FROM tblProductType WHERE ProdTypeID = " & strOneNum Set rs5 =...

Hi all, I have this code here that collects rs1("ProdTypeID") columns which contain a varchar such as (1, 2, 3, ...) and assigns each line to a var strProdTid, then break the string down to bit by using Split, and use each number in the string to locate info by using sql on the below <% do while...

This is my current code: sql = "SELECT * FROM tblProductType WHERE ProdTypeID IN (SELECT DISTINCT ProdTypeID FROM tblProducts WHERE ManuID = '" & request.querystring("ManuID") & "')" that was then when the ProdTypeID was a int and had only 1 number. Now, I changed the value into varchar where...

I 2 datas in 2 different databse: varchar strNumber = 1, 2, 3, ... int numNumber = (let just say any number) I coded: if inStr(strNumber, numNumber) then " Checked" Not working, I realized I'm comparing 2 different data, varchar and int. I tried to use inStr(strNumber, Cstr(numNumber)) but...

I'm trying to check particular box(es) with ProdTypeName that have ProdTypeID/s which match a prodtypeid string that contains one or more ProdTypeID number ex: 1, 2, 3,... <% sql = "SELECT * FROM tblProductType" Set rs1 = objConn.Execute(sql) do while not rs1.eof %> <input type="checkbox"...

Hello all, I have varchar data ID (1, 2, 3, ...) that collected from checkboxes and saved into a Products table. I'd like to use that data ID to get NAME(s)in a different PRODUCT TYPE table that have ID# matched. I know INSTR can help but I need more instruction. Could someone be more...

Hello all, My ASP pages was working ok with sql 2000 database server until we replaced the server w/ a new one and re-download SQL 2000 to the machine. New database and tables can be easily created by using WINDOW AUTHENTICATION, but NO userID and password are required to view tables, which...

Could someone tell me why this happens to me and how to fix the problem... My ASP code to display a image: <IMG SRC="/images/<% =images %>.gif" BORDER=0> and I got a "cross" unfound image. I right-clicked and found out that the output name is incorrected...

EX: I have 3 tables, Products, Manufacturers and ProductType. In the tblProducts containing both ManuID and ProdTypeID that links to the other two tables. When I call to display ProdTypeNames that associate with a particular Manufacture, the tblProducts might have the products that are the same...

I want to display only 1 output for the same data name onto a screen. EX: To find and display ProdTypeName once on screen while selecting ProductID and ManuID as well from a couple certain combo tables. by using sql2000, sql = "SELECT DISTINCT tblProductType.ProdTypeName...