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 Wanet Telecoms Ltd 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: *

  1. plasma800

    CTA 100 SW Install Locks??

    Windows XP PRO SP2 CTA 100 Software locks on install. When it gets to 50% it says installing component TFP , Please wait a moment and then it never finishes HELLLPPP :P
  2. plasma800

    BCM 50 whisper page...

    Will a BCM 50 do off hook anouncment? Like a whisper page from toshiba?
  3. plasma800

    Excell Cells keep auto formatting, DRIVING ME NUTS

    I didnt realize i could make my own custom! Ok computer saved! Thanks!
  4. plasma800

    Excell Cells keep auto formatting, DRIVING ME NUTS

    A column in excel. I need a date entered in like 2007-01-01 Everytime I type that in, it automatically changes to 01/01/2007. I reformat to general or number and it changes to 39083! I cannot find a date format of this sort in the list of date formats. How do I keep it from doing this, I'm...
  5. plasma800

    Need some help with a dynamic drop down list.

    ...drop down list of manufacturers On Error Resume Next Dim tmp Dim objTmp Set objTmp = Server.Createobject("ADODB.Recordset") objTmp.Open "SELECT * FROM bsubcat where ManfID=" & objRS("Manufacturer"), objCn, 1, 3 tmp = "<select name='SubCategory'>" If SubCat <> "" Then tmp = tmp &...
  6. plasma800

    help with portable SQL select statment

    thank you so much!!!!!!!!!!!!!!!
  7. plasma800

    help with portable SQL select statment

    Function DisplayProdConnect DisplayProdConnect = " SELECT Brand, ProdID, ProdURL," &_ " ProdSKU, Category, ThumbImageURL,"&_ " LinkText, ProdURL, ProdMiniDescription,"&_ " manufacturer, ThumbAltText FROM bProducts " &_ " WHERE Manufacturer='"&...
  8. plasma800

    help with portable SQL select statment

    Can I make this even worse? I also wanted to infuse the stuff to select. I defined a constant (maybe this is not the right thing) in my constants file for the selection Const ProdDisplaySql = "Brand, ProdID, ProdURL, ProdSKU, Category, ThumbImageURL, LinkText, ProdURL, ProdMiniDescription...
  9. plasma800

    help with portable SQL select statment

    The only reason I was trying to get the code into an include file simply for ease of adjustability. I figure if I put this sql statement on over 100 product pages and then decide I want to add something, I didn't want to have to adjust every single sql select statement.
  10. plasma800

    help with portable SQL select statment

    I need some help. I have a sql select statement that I would like to place in an include file. The SQL select statement is fed variables from the page. For Instance <% Dim manuID, CatID manuID=6 CatID="'part','processor'" Dim objRS Set objRs = Server.Createobject("ADODB.Recordset")...
  11. plasma800

    can you include asp code in a response.write..

    Can you do this response.write "<td style='background-color:#FFFFFF;'><% if objRs('ThumbImageURL') <> '' then %>"
  12. plasma800

    Select * where HOW DO I GET TWO VALUES?

    agreed! Thanks!
  13. plasma800

    Select * where HOW DO I GET TWO VALUES?

    OMG.. i left off the , objCn, 1, 3 Im so sure!!!
  14. plasma800

    Select * where HOW DO I GET TWO VALUES?

    Ive tried these and neither seem to work.. Here is my exact statement objRs.Open "SELECT ProdID, ProdURL, ProdSKU, Category, ThumbImageURL, LinkText, ProdURL, ProdMiniDescription FROM bproducts WHERE Manufacturer='6' and Category='part' or Category = 'processor'" and the page gives me this...
  15. plasma800

    Select * where HOW DO I GET TWO VALUES?

    Ok, trying to make a sql select statment that will return a record set containg two values for one column. Like this Select * from TABLE1 where BRAND='abc' or 'xyz' I want it to return all of ABC and all of XYZ but not DEF and not GHR This obviusly doesn't work but I know there is a way, I...

Part and Inventory Search

Back
Top