Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PhatH

  1. PhatH

    INSTR problem

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

    INSTR problem

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

    INSTR problem

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

    unterminated string constant ???

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

    Create Button ActionScript

    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! :-)
  6. PhatH

    Object required: ''

    :-) 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. :-)
  7. PhatH

    Object required: ''

    here is my dbconn.asp Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server};" &_ "Server=**;" &_ "Database=**;" &_ "Network=**;" &_ "Uid=**;" &_ "Pwd=**;
  8. PhatH

    Object required: ''

    thanks! :-)
  9. PhatH

    Object required: ''

    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"...
  10. PhatH

    Object required: ''

    I forgot to mention: "SELECT ShortName, ProductID, ManuID, ProdTypeID FROM tblProducts WHERE New = 1" New column is holding data in "bit
  11. PhatH

    Object required: ''

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

    Option Explicit

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

    Option Explicit

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

    Option Explicit

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

    Option Explicit

    You know what, The ERROR doesn't point to that specific DIM MenuSQL, instead, it just point to the very first line of the code.

Part and Inventory Search

Back
Top