You're right, peter_budo. I should have posted the code first time around. Anyway, here it is now

DECLARE @VisitType varchar(7) --The Visit Name with which tblWindows is to be updated

--DECLARE...

Thanks Scott, that was just what I was looking for. This was my first time working with loops in MS-SQL - very useful!

What is the best way to generate a set of dates based on today's date? Essentially, what I wanna do is:
1. Get Current Date
2. Populate a table with future dates 6 months apart and go up until I...

Hi all,
I have a form where my colleagues enter basic details about participants in a study. The 'action' attribute of the form takes the control to a 'validateForm.cfm' script where, as the name...

Thanks Scott and Ramesh,
I guess the next thing for me to do is look into FTI - I have just started working on this DB, so I am not quite sure if there are any indexes at all in it!

I am using MS-SQL 2005 DB. One of the tables in the DB, that I inherited, has gotten upto 37000 records. And it will go up by another 50k records soon. Does that make too much data for one table? The...

I just got back to this site and implementing the login feature again. There is something I am not doing correct. After 5 unsuccessful login attempts, a trigger in the DB flips the AccountStatus bit...

Does anyone here have experience using the Acunetix Web Vulnerability Scanner? I happened to use it on my site to check for vulnerabilities and found about 15 HIGH level ones - all of them with...

I am using the SQL 2005 Express edition for SQL server. The database resides on another server and I connect to it from my machine through the object explorer. I have created a trigger to run certain...

In addition to what thesaintbug said, there is another thing you might need to change. Rather than 'Encrypting' passwords, the better option would be to Hash them. Hashing is a one-way process -...

In your form declare a hidden type input and set it to 'strPassword'
<input type="hidden" name="OldCode" value="<cfoutput>#strPassword#</cfoutput>" />

and then change the comparison <cfif> to...

I have only had a few minutes to look at the code and the problem I see is that the value in your text field is being compared with the NEW spamcode; not the one that is generated for the page that...

The text field values need to be stored using #ListGetAt(FORM.txtValue, getIDs.CurrentRow)# instead of just 'FORM.txtValue'

Thanks buddylee17,
I am not sure why I did not think of those functions! :-O

I have a bunch of alphanumeric IDs for the data in my DB. The IDs may look like the foll:
0XAA001 or 1YBB010 or 2ZCC011 and so on.

Each of the 7 characters stands for something and therefore I...

Wowww JasonHippy! That explanation deserves more than a few reputation points!! Thanks for the detailed description!

Thanks fayola! Just the last part of my original query - What (if anything) do I need to check with the organization that hosts my website to make sure Flash works as expected?

Hi all,

I am a complete newbie when it comes to Flash programming. I am basically a server-side programmer with more than enough knowledge of client-side technologies. However, Flash is something...

Actually, there are only 2 rows. So like the following:
Table:
Column 1, Column 2, Column 3, Column 4
Row 1
Row 2

What I want now is:
var 1 = Row1.Column3
var 2 = Row2.Column4

Is there a way to grab data from alternate records in a ColdFusion query?
Essentially, what I am trying to do is this:
I am querying my database to grab some data. 2 rows of data are returned...

Thanks almostbob and sgweaver for your help. I am almost there and a little more experimenting with the CSS should get me through!

Here's an example of a simpler 3-dropdown box form with which I am struggling with the positioning.

I wanna arrange the 3 drop down boxes next to each other, but their labels should be exactly...

Hi,

I have a form that has a bunch of cascading drop downs - something like Country->State->City->. Each subsequent drop down is populated based on what is selected on the preceding one.

What I...

Woww... I missed an easy one there. Thanks Saion!

I have a table off which I need to parse out the data using certain criteria. The table contains 3 datetime columns called 'ReadingTakenOn', 'StartedOn', and 'StoppedOn'

Here's the criteria for...

Here's the problem:

One of my scripts allows users to upload MS-Excel files. When uploading the file, users are also required to enter details related to the file - details like start date, stop...

Could someone help me figure out how to disable user accounts in ColdFusion? What I am trying to achieve is this:
When a user makes 5 successive invalid attempts, his/her account will be temporarily...

Hi all,

All right, here's what I am trying to achieve but have no idea how to do it:

My site requires users to login and every page is password protected. As part of preventing hacking (to a...

Hey Guys,

I have just started working on ColdFusion, so I am relatively new to it than most of you may be. I am trying to create 'Sticky Stay-Filled' forms so that when the form is submitted, the...