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: …

[QUOTE=peter_budo;1038374]So if you have written that code why didn't you posted so somebody can have look at it and tell you what can be wrong? So far it does look like you posted your assignment and expect somebody else do it for you...[/QUOTE] You're right, peter_budo. I should have posted …

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 …

[QUOTE=pirula;953826]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 …

In addition to what [I]thesaintbug[/I] said, there is another thing you might need to change. Rather than 'Encrypting' passwords, the better option would be to Hash them. [I]Hash[/I]ing is a one-way process - which means no one will be able to guess what a user's password is even if they …

[QUOTE=martincarter71;941227]Hi SQL_n00b, You might be able to change [icode]<cfif isDefined("FormSubmitted")>[/icode] to [icode]<cfif isDefined("Form.Submit")>[/icode] where Form.Submit is the name of the submit button. Thanks MC[/QUOTE] The text field values need to be stored using [icode]#ListGetAt(FORM.txtValue, getIDs.CurrentRow)#[/icode] instead of just 'FORM.txtValue'

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 …