CFUPDATE-ing without a form?

Dear list, Is there any way to CFUPDATE without using a form?  I'd like to pass the data as variables in the URL. TIA, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

SOLVED: CFUPDATE-ing without a form?

Wow.  Many, many thanks to Michael and Matthew and their very quick responses! Best, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

setting a default value in my SELECT tag

Dear list, I'm sure there is a simple answer to this basic question.  Sorry for being such a noob: I'm working on my first application!  I hope to become a useful member of the CF community one day.  But first you will have to put up with my stupid questions for a while. Stupid question the se

SOLVED: setting a default value in my SELECT tag

t and cringe one day. Thanks again. CK. On 19 Aug 2004, at 1:55 am, Ewok wrote: > try this on for size > >   >   >   > selected>#projectname# >   >   >- Original Message - >From: Chris Kavanagh >To: CF-Talk >Sent: Wednesday, August 18,

Inserting into multiple tables

Dear list, So here I am, at the last line of defence, so to speak: my first app is due today! Luckily, I'm nearly finished, but I have another stupid question for you lot, my new favourite people.  I'd like to insert values from an insert form into two separate tables.  I'm planning to use a S

Re: Inserting into multiple tables

>  In my backend Access database I have a relationship between two > tables: > >  TASKS PROJECTS >  Project --> projectsID [key] >  projectname That didn't survive reformatting very well.  Let me try again: TASKS project (linked to projectsID) PROJECTS projectsID (the key) projectname [Today

SOLVED: Inserting into multiple tables

ly passing the projectname, but you need the projectid? If so, > you >  can display the projectname and pass the projectid. On your form, > just do >  this: > >   >  #projectname# >   > >  - Original Message - >  From: "Chris Kavanagh" > >  !

500 error until I refresh

Dear list, Here's an odd one.  My page projects.cfm links (via a standard HREF="" to the page newtask.cfm. In my browser I get an HTTP 500 error - ("The page cannot be displayed...") but when I refresh it it loads fine.  This hasn't happened in any of my other .cfm pages - any ideas? I am run

SOLVED: 500 error until I refresh

:D  I fixed it all by myself.  I found the clue in the server log.  I'm turning into a coder! On 19 Aug 2004, at 3:03 pm, Chris Kavanagh wrote: > Dear list, > >  Here's an odd one.  My page projects.cfm links (via a standard >  HREF="" to the page newtask.cfm.

Re: SOLVED: 500 error until I refresh

> heh good job, what was it I was CFOUTPUTing a value that I hadn't CFQUERYd.  Rookie mistake... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

A bit confused with links between tables

Dear list, As the witching hour approaches and my first deadline draws near, expect my stress levels to climb and my emails to get less and less graceful.  For now, I feel remarkably composed, although I don't suppose I'll be getting to bed anytime soon. Now: this query fetches some data from

A bit confused about links in my data

Dear list, As the witching hour approaches and my first deadline draws near, expect my stress levels to climb and my emails to get less and less graceful.  For now, I feel remarkably composed, although I don't suppose I'll be getting to bed anytime soon. Now: this query fetches some data from

I love you guys

all of you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: Exactly *how* smart are we?

> I follow most of these discussions on CF, and it's obvious there are >  some extremely intelligent people here. I'd like to invite everyone >  to visit the International High IQ Society Website... I've always been a little sceptical when people suggest a subject so complex and diverse as human

CFMX dedicated hosting

Dear list, I'm considering getting my own (as opposed to a shared) CFMX server for a big project.  Are there any good hosting companies in the UK?  I'm already aware of a company called Satachi. Kind regards, CK. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User S

Re: Breadcrumbs - do you fully track users?

> What do you do for breadcrumbs on your sites?   Do you display the > actual >  route the user took to get to this page or do you show the normal 3-4 > steps >  from the home page, regardless of the way the user actually got there? To me the purpose of breadcrumbs is more to show the navigation

Access alternatives (WAS: Security gurus out there?)

>  If you're storing lots of sensitive information in a web application, > DON'T RUN IT ON ACCESS!!! Access is a desktop database, threads > frequently crop up on here with lots of info on why it's really NOT > suited to a server environment... What's a better choice?  SQL Server?  Does anyone

Re: WWOT: OS X for Intel?

>  Could Apple make a dent in the windows desktop? > >  Is this the time and place? > >  Should they? Right now they have an interesting opportunity.  Consumers normally have to pass through six "buyer-readiness stages" before they make a purchase: 1. Awareness "I'm aware of the brand" 2. Kno

Appointments scheduling system

Dear list! So I've got to make an appointment scheduling system for a doctor's surgery.  I really can't be bothered to code it myself...does anyone know of an existing CF system I could buy, or any open source stuff I could easily repurpose? Kind regards, CK. [Todays Threads] [This Message]

Variable is not defined

Dear list, How do I set a variable to null (or "no" or something) if it's not already defined? Thanks! CK. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/b

Too stupid for CF

Dear list, In my task management system, certain people have access to certain projects. I'd like an admin screen for each project that displays all the people with a checkbox beside their name. The sysad can check or uncheck people as necessary. But I'm a bit confused how best to execute th

Attribute validation error for tag cfloop

Dear list, I'm getting this error message: -- Attribute validation error for tag cfloop. The value of the attribute query, which is currently "insert_people", is invalid. -- I guess there's something wrong with my INSERT statement but I can't figure out what it is. I've tried permutations

CFLOOP not looping

Dear list, My CFLOOP doesn't seem to be looping my INSERTS. A form passes the variables #person_id# & #project_id# to this page: SELECT person_id FROM people WHERE person_id = '#Form.person_id#' INSERT INTO people_project (person_id, project_id)

Re: CFLOOP not looping

On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote: > are you sure your query is returning records? do a > #get_people.recordcount# after your to > make sure. Ah! Now we're getting somewhere. No: when I check multiple boxes on the form that gets me here, it sends one value, like this: 1,7 W

SOLVED: CFLOOP not looping

:D it now loops. The IN clause fixed it. Thanks everybody. - ck. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a clien

Calculating lead time

Dear List, So tasks in my task management system include these fields: deadline(date - MySQL "date") leadtime(number - MySQL "tinyint") leadtime_type (minutes, hours, days, weeks - MySQL "varchar") On the "task list" view (an html table), I'd like the table rows

My CFSET error

Hi List, This CFSET is returning the error: "Variable DIFFTYPE is undefined." -- -- :/ Can anybody see what I'm doing wrong? Thanks guys, CK. ~~

SOLVED: My CFSET error

Thanks everybody, this was the problem exactly: > Your switch expression is the text "lead_time_type_id" which does not > have a > case. If you mean it to be a variable of that name, you have to place > pound > sighs around the variable. > Like so: > ~~

CFUPDATE throwing up a weird error

Dear List, This CFUPDATE looks okay to my noobish eyes: -- -- [#name# is the primary key] Yet when I run it, it's throwing up this error: -- Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax; check the

Re: CFUPDATE throwing up a weird error

> "Name" may be a reserved word depending on your DB Thanks very much, Bryan, but that doesn't seem to be the problem. I renamed the field to "banana", and it still doesn't work. I'm kind of stumped. Anyone else got any ideas? I will take your other advice about learning more SQL, but just so

CFUPDATE-ing without a form

Dear list, I have a URL variable like so: change status to 2 Going to a CFUPDATE like so: I was hoping it'd change the relevant status_id to 2, but no, it doesn't seem to do anything. Not even give me an error message. Can anybody help? Is it because

A newbie approaches user authentication

Dear list, So, my first app is finished - except for user authentication. I thought I'd save the most difficult bit until the end. I guess CFLOGIN is the way to go, so I took a look at this tutorial: http://tutorial67.easycfm.com/ and, to my shame, didn't really understand it. I was doin

help-a-noob: Null Pointers

Hello list! It's 12.47pm and I didn't go to sleep last night. Thank the goddess for illegal stimulants. So I'm bashing my exhausted head on the desk with this error message: -- The system has attempted to use an undefined value, which usually indicates a programming error, either in your c

[SOLVED] Re: help-a-noob: Null Pointers

And seconds after crying for help, I realised what it was: a null field in my backend database that can't be null. I know, I know. I'm very tired, okay? Sorry to waste everybody's bandwidth. Best regards, CK. ~| Logware (www

rookie: link table

Dear list, My task management app gets a list of tasks, like so: -- SELECT tasks.task_id, tasks.name AS taskname, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id,

Re: OT rookie: link table

>> people.person_id > hahahahahhahahhahhhaahaha.ah. sigh. > > sorry Chris, back to the topic. <:| uh? I love it when I'm funny but it's a bit disconcerting when I don't know why. >> it only gets TASKS that belong to the PROJECT that the PERSON > is cleared for > > Im not sure how

[SOLVED] Re: OT rookie: link table

Many thanks, guys, that now works perfectly. Kind regards, CK. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client wit

Preventing users CFINSERTing duplicate records

Hello list! Well, that's it really. What's the best way to prevent a user from inserting duplicate records? FYI in this case it's going into a MySQL table that has only two columns: -- co_id co_name [PKey] -- Thanks! CK. ~~~

Making a game!

Dear list, I've been asked to help make a web wargame! I was wondering if ColdFusion is a capable tool. I'm basically envisaging a database that contains details of each side's forces. Each turn, the players send commands via a web page. Ideally CF then calculates the results of said comman

basic: outputting data from several tables in one CFOUTPUT

Dear list, I've got this query that gets data from three tables: SELECT tasks.task_id, tasks.name, tasks.deadline, tasks.project_id, tasks.importance_id, tasks.owner_id, projec