Search results for query: *

Excellent! That did the trick, it's working just fine now! Thanks so much for all your help!

You were right, that was the reason why it wasn't sending anything. It sends mails now, but in the strange 'pyramid' kinda way I had before... I tried it in tow different ways: //way one $interestMessage .= '<P>'.$message[$sRow["interesse_id"]]; //way two $interestMessage =...

Hello, Thanks again for your reply! :-) I allready figured out myself what dot was wrong. But it still isn't working OK. When I send a message, everything seems to work fine, and just one e-mail is sent to everybody on the list. But - only the general text is in it and none of the...

Once again - thanks very much for your help, I really appreciate it! You're right, I have multiple records per userID. Also kinda my mistake, it's a bit difficult for me to explain everything in a clear way in English. Anyway, I copied your example and I still got a little error. If I open the...

Thanks again for your help! You were right, this solved the 'pyramid-effect'! :-) But now, a new mail is sent for evey interest. So if somebody is signed up for interest 1 and 2, he now receives 2 seperate e-mails, both with the general text, but one with just text 1 and the other one just...

Hello, Thanks for your advice, it helped me out quite a bit! The system now actually sends mail to every address in the database. But it's still not quite working the way I want it. Let me sketch a situation here. Let's say this is the result of the query: SELECT personen.persoon_id...

Hello everybody, I'm working on a PHP newsletter system for my website. As people subscribe for the newsletter, they need to choose their fields of interest from a list of 5. They need to pick at least 1 interest, but can also pick all 5. If a newsletter is sent, there is a text that everybody...

Hello, Thanks very much for your reaction. I tried it immediately, but when I run the script, I get the following error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource etc, etc... Do you know how this error is caused? Does it have something to do with the...

Hello everybody, I'm working on a newsletter system in PHP4 & MySQL. People can subscribe for the list, and can choose their areas of interest. There's a minimum of 1 and a maximum of 5 interests. I allready have the main mailingsystem working, but I want it a little more complex. I've...

Hello everybody, I created a report in Crystal Reports 7. I connected the report to a CRM-system which is only compatible with CR7. A client-version of CR7 is included with the CRM-system. I want the data in this report sorted in a special way. To achieve that, I manually adjusted the...

Hello everybody, I created a report in Crystal Reports 7. I connected the report to a CRM-system which is only compatible with CR7. A client-version of CR7 is included with the CRM-system. I want the data in this report sorted in a special way. To achieve that, I manually adjusted the...

Hello Reebo, Thanks for your advice. Not sure if I actually had to download those files, but I changed the formula a little, and now it's working OK. I used your first example, and changed it this way to get it work: Local StringVar SMS := {REL_PERSOON.TELEFOONMOBIEL}; SMS :=...

Reebo, Thanks for your reply. Yes, the phonenumbers are stored as strings. The name of the database-field is REL_PERSOON.TELEFOONMOBIEL I tried to put your examples in a formula-field, but I get an error with both. Maybe it is good to repeat that I'm working with Crystal Reports 7. With the...

Hello everybody, I'm creating a report in Crystal Reports 7, for export of names and phonenumbers to an SMS-application. The problem is that the phonenumbers are in my system in many different formats. A few examples: 06 51238745 06 - 51238745 What I need to do is remove the spaces from the...

Hello I've the following problem: When I add a character to a numeric field in a formula field it becomes a String field. ( example: 'X'+ToText ({Table.Field_ID}) ) I don't want the Field_ID to have a thousands separator, but because I changed it to a String field, it isn't possible to change...

Hello everybody, I have the following problem with Crystal Reports formulas (I'm working with version 7). I want to make some sort of SQL-selection, a selection with conditions. So far, I have the following formula: if {OPL_UITVOERING.STATUS_CODE} = &quot;DE&quot; or...