Recent content by jackfl

I haven't set up a secure site in a while, but here's what I remember... Create a new web site for the secure content; probably from the page which requests the SSN number thru any display of sensitive information. This will look just like your existing web site config except it will be on port...

Use CInt instead of FormatNumber...

SELECT TOP 10 myColumn FROM myTable ORDER BY myColumn DESC

This is often a bad compare syntax...try adding in CStr and Trim...

Write the SQL string out to the screen and see if it returns rows via Query Analyzer...

In the example SP I pasted I insert 2 records into years for each new person...the first is their planned hours and the second is just a ZERO placeholder for their actual worked hours... Your SP might look something like this: CREATE PROCEDURE insert_something @license_seq_number int AS...

I have a tendancy to use Stored Procedures for such work... CREATE PROCEDURE insert_new_pers_wr_records @act int, @wr int, @pid int, @JanNew real, @FebNew real, @MarNew real, @AprNew real, @MayNew real, @JunNew real, @JulNew real, @AugNew real, @SepNew real, @OctNew real, @NovNew real, @DecNew...

Perhaps: If Rem(workingDate/2) = 1 Then bgcolor='#ffffff' Else bgcolor='#ff0000' End If

CInt(MyArray(3)) + CInt(MyArray(4))

I think that refers to apartment threading... Dim Application("aryName")

Wouldn't it be easier to change the SQL query to something like: SELECT * FROM TABLE WHERE pid = " & request.querystring("id") ?

Do you need to close your connection to the DB? Is it possible that you are running out of connections, and that is creating random results?

Verify that your web site has an Application Space set up for it...under IIS...if you don't see a Remove button next to the Application Name field then your global.asa will never get read...

The way you set up an auto-number field in SQL is with Identity = Yes. If Identity is set to No and Allow Nulls is not checked then you will get an error when you don't explicitely INSERT this field as well.

WHERE field1 LIKE '%Lumber%' OR (field1 LIKE '%Heavy%' AND field1 LIKE '%Carpet%')