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

    Here's the point. I load a page of all of my products details in my admin section so that my people can adjust product records. All of the main product info comes from a table "bProducts" Certain items come from other tables, like Manufacturer or Category or SUB category. in my newly made...
  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