Recent content by Dutchguy

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

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.

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

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

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

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

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 ?

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

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 ?

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