cheapterp

I have a bunch of records that I get from doing multiple joins. # Name, ID, Date, Gender, Birthday # John Doe 111 01/02/2003 M 01/01/2001 Jane Doe 222 03/04/2005 F 02/02/2002 Jane Doe 222 **03/05/2005** F 02/02/2002 Jim Doe 333 07/08/2009 M 10/11/2012 What I am trying to get …

Hello: I have a table where a column called [I]ActiveStatus[/I] (of datatype 'bit') I am trying to run a query on may contain values Boolean values or NULL. Which means, if there are 10 rows in the table, a likely scenario would have 5 NULLs, 2 FALSEs, and 3 TRUEs. …

Hi all, Of late - since maybe about 2 weeks back - my laptop just refuses to enter standby and hibernation. I have set my PC's Power Options to send it to one of these power saving modes depending on how long the machine has been sitting idle. PC config: …

One of the UPDATE queries I am trying to run is not quite working the way I want it to. I know this query is the culprit, but can't quite figure out how to fix it! Here's the story: ------------------------------------------------------- I have 3 tables: let's call them tblUsers, tblDueVisits and …

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 reach, let's say, 12/31/2020 I have looked at some of …

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 suggests, form validation is done. If there are any problems, I show the errors as well …

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 table has about 25 columns, most of which contain …

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 small extent, though) I am trying to [B]TEMPORARILY[/B] disable the user's account …

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 basically the same problem: [B]Cross Site Scripting[/B] and [B]Cross Site Scripting in URI[/B]. For every …

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 queries and updates, but can't seem to find the trigger listed under [QUOTE]MyDB->Programmability->Database …

I am so confused, I want to add some anti-spam security to my upcoming register page but something is really wrong. Note that my server is Coldfusion MX7 (i can not afford better) and because of that i can not use cfimage(captcha). This is what i have: [code] <cfset strLowerCaseAlpha …

When a user logs in that has the same password as another user the latest person to register with that passwords details are revealed, im struggling to make it check that the username and password are connected and only if the username and password match should that users details be …

I have a table that has various rows of data grabbed from a table in my DB. 3 of the columns display the queried data. The last column, however, contains text fields for the user to hand-enter values. When the user hits the Submit button, all of the values entered …

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 have to extract the characters to populate the columns in the …

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 here. Now I want to set 2 variables - [I][B]var1 = row1.columnA[/B][/I] …

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 I am keen on learning. I was looking for info on the following about Flash: 1. What kind of …

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 am having trouble with is the positioning of the labels for these dropdowns. For ex., I …

I have a table off which I need to parse out the data using certain criteria. The table contains 3 datetime columns called '[B]ReadingTakenOn[/B]', '[B]StartedOn[/B]', and '[B]StoppedOn[/B]' Here's the criteria for selecting the records: The Dates in the 'ReadingTakenOn' column should lie between the Start Date and Stop Dates (both …

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 date, a description of what the file contains, and the file ID#. This Excel file contains …

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 locked for 20 minutes, after which they can try logging in again. If after the first …

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 details entered on the form show up on the page following the …