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 strongm 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: sladewilson
  • Order by date
  1. sladewilson

    How do I find records in groups, make changes and continue...

    I have an ASP intranet application powered by an Access database. The database holds all my product data, shoes to be exact. I need to be able to process groups of items with the same NAME then proceed to the next group and run the same process again... how can I do this? The data looks like...
  2. sladewilson

    How can I make this happen? Example shown.

    This is basically what my product data looks like: SKU Name Size Price On-Hand 4900 Bogs Shoe 59.99 4907 Bogs Shoe 6 59.99 11 4915 Bogs Shoe 6.5 59.99 9 4923 Bogs Shoe 7 59.99...
  3. sladewilson

    Renaming Images...

    Kiddpete, Thanks for the suggestion. But I need a way to rename the pictures using a data MAP ie. from a data source. See my example in the original post.
  4. sladewilson

    Renaming Images...

    I have a directory full of images (about 2000 of them). The images all have numeric names that match item numbers in a database... example Item #1378 might be a Blue Shoe and the picture for that shoe is named 1378.jpg I have to use a new database application that is gonna start with item #1...
  5. sladewilson

    How did they do this???

    Ok cool... I understand what they are doing there.... but back to the original question..... how did they make the border on the table without messing up the header. Notice there is no red line at the top of the header of the table. Only the right, left and bottom have the red line border...
  6. sladewilson

    How did they do this???

    But aren't they applying styles to the div tag? I mean... look at the code you pasted... there is no reference to the background image... the reference has to be coming from CSS... am I wrong?
  7. sladewilson

    How did they do this???

    What I basically want is a faded color background image in the title area and a colored border around the rest of the table. I found some examples at WWE.COM Check out the two tables on this page... One is titled "BETH PHOENIX PHOTO GALLERY" the other is labeled "BETH PHOENIX VIDEO GALLERY"...
  8. sladewilson

    Viewing Fonts...

    For all the features Photoshop has... I can't believe they overlooked this one. I'll do what you said.... just install some simple program that displays font faces. Thanks for the tip.
  9. sladewilson

    Viewing Fonts...

    Is there an easy way to view the font face for the fonts I have without having to open each font one by one... I mean... is there a way to view what the font looks like in a sort of quick list? I have 2000 fonts... how do you guys manage this sort of stuff?
  10. sladewilson

    Finding edges and cropping...

    OMG!!! You are a GOD!!!! Too cool! It works like a champ!!!! Where do I send the free beer? LOL!!!! You just saved me MANY hours of tedious work!!! Tipmaster Star for you!!!
  11. sladewilson

    Finding edges and cropping...

    I have about 500 pictures of cd's. As we all know 99.9% of CD's are the same size. But whoever made the pictures took them at different distances, thus some of my CD's look large and others look smaller...yet all of them are on a white background (thank god). I want them to all look uniform on...
  12. sladewilson

    Select Statement help....

    opps... left out this part... delimiter = " AND "
  13. sladewilson

    Select Statement help....

    ..."category1") where = "" delimiter = " WHERE " For fnum = 0 To UBound( formFields ) fval = Request.Form( formFields(fnum) ) If ("X" & fval) <> "X" Then where = where & delimiter & dbFields(fnum) & " LIKE '%" & fval & "%'" End If Next objRst.Open "Select * FROM Products " & where %>
  14. sladewilson

    Select Statement help....

    ...that my syntax is not correct but I don't know where to find examples. This works like a champ (but shows all records): objRst.Open "Select * FROM Products " & where I want to filter out all records marked as deleted. The field in the database is named "deleted" and the value in the field...
  15. sladewilson

    Simple code problem...

    Thank you so much.... where can I find a good reference of sql syntax?
  16. sladewilson

    Simple code problem...

    ...value. strCategory = Session("Category") Response.Write (strCategory) So I know the Session is set correctly. Now I try this and I get FROM clause errors... objRst.Open "Select * FROM Categories WHERE category_name = (strCategory)" Response.Write objRst("category_code") objRst.Close Any...
  17. sladewilson

    Simple code problem...

    Not sure... here's the rest of the page... Dim strBrandCode objRst.Open "Select * FROM Brands WHERE brand = " & Session("Brand") & ";", objConnect strBrandCode = objRst("brand_code") objRst.Close Dim strCatCode objRst.Open "Select * FROM Categories WHERE category_name = " &...
  18. sladewilson

    Simple code problem...

    What is wrong with this... <% Dim strProdCode strProdCode = strCatCode &"-"& strBrandCode &"-"& strProdId Response.Write (strProdCode) %> I want output that looks like this: shoe-nike-2838
  19. sladewilson

    Exporting Data Problem with Line Breaks...

    I am exporting from Access to CSV so I can upload the product database to my Yahoo Store. Everything works great until I add options to products (due to the line breaks on the rows that contain items with options).

Part and Inventory Search

Back
Top