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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: PhatH
  • Order by date
  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.
  16. PhatH

    Option Explicit

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

    Option Explicit

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

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

    Object Require: &quot; ?????

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

    Object Require: &quot; ?????

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

Part and Inventory Search

Back
Top