Search results for query: *

Hello, I am trying to implement some kind of Picture / Code Verification so malicious users cannot spam our system. An example of what I am trying to set up can be found at: https://www.godaddy.com/gdshop/whois.asp You enter a domain name and click "Go". You then have to type in the number...

I have been stuck 2 days on this code. I am using Perl to create directories with HTML files. The directories are being created but the HTML files are not. Can anyone see what is the problem with my code here? Any suggestions or information would be appreciated. Thank you in advance...

I am trying to write a VB function to replace these awkward characters in a string: Replace with Single Quote ('): ’ Replace with DASH (-): – Replace with 2 Single Quotes (''): “ (or) †Replace with 3 Periods ( ... ): … Function CleanString(strInput) mySTemp =...

I have a string with commas and numbers which can be any number and in any combination. For example: 1, 2, 4, 23, 58 1, 2, , , , , 23, 58 1, , , ,2, 4, 23 , , , , 58 , , , , 1, 2, 4, , 23, 58, , , 1, 2, 4, , 23, , , 58, , Regardless of where the commas are, I want to be able to return a...

I have a string with commas and numbers which can be any number and in any combination. For example: 1, 2, 4, 23, 58 1, 2, , , , , 23, 58 1, , , ,2, 4, 23 , , , , 58 , , , , 1, 2, 4, , 23, 58, , , 1, 2, 4, , 23, , , 58, , Regardless of where the commas are, I want to be able to return a...

User Table UserId, UserName, UserAddress, UserRecordDate ... Chemical Table ChemicalId, ChemicalName, ChemicalRecordDate, ChemicalContactEmailAddress, UserId Each user can have zero (0) to many chemicals. I would like to create a SQL statement to get: 1) Number of Chemicals By UserId 2)...

Does anyone know how to rename IIS STMP Virtual Server? I am trying to rename it so when emails are sent, it will show that email source is for example "mymailserver.domain.com"? Please help. Any suggestions or information would be appreciated .

Does anyone know how to rename IIS STMP Virtual Server? I am trying to rename it so when emails are sent, it will show that email source is for example "mymailserver.domain.com"? Please help. Any suggestions or information would be appreciated.

Our outgoing email uses the DNS servers from GoDaddy. Our domains use the DNS server from ZoneEdit. I am trying to set up a mail server at home using SMTP Service in W2K IIS. I have no MX records, CName, PTR, etc. for this server. The problem is other SMTP servers cannot do a Reverse-DNS so...

I use SMTP Service in Win2K to send email. I have SMTP "Virtual" Server set up in IIS, but this is not the same as Exchange Server. No DNS server is used. About 20% of my emails are stuck in queue. I get the following messages in Event Viewer: Message delivery to the remote domain...

I have the following code where @chemicalTypeId is a parameter in my stored procedure GetRandomChemicals: select * from chemicals where chemicalTypeId1 = @chemicalTypeId or chemicalTypeId2 = @chemicalTypeId or chemicalTypeId3 = @chemicalTypeId or chemicalTypeId4 = @chemicalTypeId...

I would like emails from NewsletterSubscriber, and non-duplicate emails from Users, and then non-duplicate emails from Users (in database 2) in that order. For tracking purposes, I am using "MyUserOrNewsId" and even with the use of UNION, the emails returned has duplicates. Please help...

I am new to using sql server stored procedures and CDONTS to send HTML email. I am using "DECLARE @body VARCHAR(8000)", and the stored procedure compiles and sends the email. When I look at the email in my mailbox, the email gets cut off around 15,000 characters (I have over 20,000 characters...

I am writing a SQL stored procedure which uses a cursor to send email to various people. How can I get unique emails from EmailTable1, EmailTable2, and EmailTable3 in "one" SELECT statement? Each person in EmailTable1 can also be in EmailTable2 or EmailTable3, etc. Please help. Thank you...

I have 2 fields email1 and email2 in a Email Table. These fields contain multiple email addresses separated by commas. There can be up to a 6 emails in the 2 fields. For Example: Email1 can be "joe@joe.com, joe2@joe.com" and Email2 can be "joe3@joe.com, joe5@abc.com" Concataned value of...

I need help writing a Stored Procedure that cleans out Letters, Commas, Periods, and $ (dollar signs) in the price field (database type: varchar) of a Product table. The price field is in the Product table, where the primary key is ProductId. I am new to this. Please help. Thank you in advance.

I have a table Chemical that has the following fields. chemicalId - primary key chemicalShortName - eg. viagrasium chemicalFullName - eg. viagrasium dio sulphate chemicalNameUsed - eg. viagra chemicalCompanyShortName - eg. ABC Pharmaceutical chemicalCompanyFullName - eg. ABC Pharmaceutical...

I am writing a SQL Server stored procedure that returns chemicals that match the chemicalIdString parameter. @chemicalIdString is a string of chemical ID's separated by commas. Example -> '10, 9, 7' When I run: sp_GetChemical '10, 9, 7' I get the following error: Syntax error converting...