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!

Register Log in
  • Congratulations Chriss Miller 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. Dutchguy

    Emailing search results

    Have been playing with it all evening, but no luck. Anyone can help with this ?
  2. Dutchguy

    Emailing search results

    Unfortunately not working, It now displays one result, and the wrong result for the wrong person. I get your point though, but it's not working out yet.
  3. Dutchguy

    Emailing search results

    At this point I have the following code: Set rs = Server.CreateObject("ADODB.RECORDSET") rs.Open "Select * from Matchen where description Like '%'+Zoekopdracht+'%'", Conn body = body & "Your search results:" & "<br>" & "<br>" While NOT rs.EOF body = "" body = body & rs("description") & "<br>"...
  4. Dutchguy

    Emailing search results

    I don't think this is what I mean. The number of client's and search results will always be different.
  5. Dutchguy

    Dynamically creating a password

    I use the following function: length_of_password = 8 function MakePassword(num) dim i, intNum, intUpper, intLower, intRand, strPartPass Randomize For i = 1 to num intNum = Int(10 * Rnd + 48) intUpper = Int(26 * Rnd + 65) intLower = Int(26 * Rnd + 97) intRand = Int(3 * Rnd + 1) Select Case...
  6. Dutchguy

    Emailing search results

    I have a SQL statement that returns the following list: Email | Client_ID | Search | Description test@test.com | 1 | chevrolet | chevrolet, in new condition test@test.com | 1 | chrysler | very nice chrysler, $ 500 mail@mail.com | 2 | chrysler | good...
  7. Dutchguy

    Mail bodytext and loop problem

    Thanks for your reply. It's not completely working in your example. With your example it is now only sending one e-mail with all th results in the body text. In my testdatabase, there should be two e-mails out, within each e-mail the right search result. Any ideas ?
  8. Dutchguy

    Mail bodytext and loop problem

    I have the following two tables, that match against each other. (This system has to be an automatic notifier by e-mail when someones search-criteria in the database matches with the data of vehicles that are for sale). Example: Test.Model Test.Type BMW 316 Mercedes SLK Opel...
  9. Dutchguy

    Image in Report

    Hi, I import an text file to a table. The text file contains numbers and hyperlinks to images on the internet. When I import everything I only see the hyperlinks to the images, and not the images itself. I want the internet images to appear on my reports. Is this possible, and how ?
  10. Dutchguy

    bitesize

    Hi, Does anybody know how to figure out the bytesize of an email sent with cfmail? I coun't find a cffunction for it! Tnx

Part and Inventory Search

Back
Top