Search results for query: *

Is the Conversion correct here or is there a simpler way. CREATE PROC spUpdateTokenScore AS SET NOCOUNT ON -- Suppress record count messages for a performance boost. -- Declare two variables. DECLARE @HAMS Numeric(18,4), @SPAMS Numeric(18,4) -- Populate the variables with values from the...

Here is a VB Function which you can parse all your SQL Text through: Public Function SQLEncode(sqlValue As String) As String On Error Resume Next ' NOT really needed SQLEncode = CStr(Replace(sqlValue, "'", "''")) End Function Brian Gillham FailSafe Systems

Heres the answer. Just use Visual Studio .NET (just kidding) but here is a link to a FREE Utility that will solve all your problems. http://www.freevbcode.com/ShowCode.Asp?ID=109 Brian Gillham FailSafe Systems

Be careful when using Shape you cannot use a normal connection string. You have to use the SHAPE Provider. The first thing I would check is the Cursor. You CANNOT use Server Side Cursors with the SHAPE Command. Brian Gillham FailSafe Systems

I need to be able update all the rows in Table using information from another Table and a Formula. EG: Table #1 (Only has ONE Record) GoodMails (Int) BadMails (Int) Table #2 Tokens (String) GoodTokens (Int) BadTokens (Int) Score (Numeric(18,4) I only want to read Table 1 ONCE I then need to...

Only the Tokens are Delimitered with "^". Basically a case of split Tokens and split again to access the values. Brian Gillham FailSafe Systems

My Spam Filter is working great using Bayesian Filters and for those of you who want to know how Bayesian Values are calculated the following procedure should explain it. Anyway on with my problem. I want parse ALL the Tokens that I have collected when I process the Email to a Stored Procedure...

Duh - Looks like I had a blonde moment :-) Thanks for the reply, sometimes the more you look at something the more invisible it becomes.

I have this strange problem where a Calculation in my Stored Procedure only shows the Int Value. The Code below always returns 0 or 1 and never the decimal value. Can some on help? DECLARE @HAMS int, @SPAMS int, @GOOD int, @BAD int, @SCORE decimal(14,3) SET @HAMS = (SELECT...

Be careful when using dates with SQL and ACCESS databases.<br> Firstly SQL is ALWAYS in the format MM/DD/YY<br> While Access uses the date format in the regional settings.<br> When / if you internationalize your apps these are important considerations.

Why not use the Immediate window to Evaluate Expressions. Or am I not understanding your question

Try this:<br> If RS.State = adStateClosed then<br> RS.Open<br> End If

Once you update using Client Side Cursors - Do a RS.Requery<br> Do not use Server Side Cursors with Access - Do as above.

Seagate have a free version of their Report Writer for VB6. The samples include a preview window.