List issues

I have sent the same message about 3 times too and it hasn't shown up. Stu ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door

hOf - just a test - ignore please

A short test ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly

Getting the query right

Hi guys, I have a job site which when users register they get to choose categories for work which may suit them. I would like to write a schedule that will email the users new jobs if they are in one of their chosen categories. Right now I have a table called UsersToWorkCategory which has

re: cgi.referrer

Hi Scott, This is the sort of thing I use: cfswitch expression=#CGI.SERVER_NAME# cfcase value=clubguide.020.com !---start of include header--- cfinclude template=/index_clubguide.cfm !---end of include header--- cfabort /cfcase cfcase

OT: Escrow services

Hi guys, I'm wondering if anyone has any experience with Escrow companies.  I'm about to launch a website where i'll need to take funds off one person and put it into an escrow and then at a later date pass the funds on to another person (and at this stage take a 5% commission).  So similar to

Decimal

Hi guys, Is there any way to check whether my variable is in fact a decimal? Thanks, Saturday ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229443 Archives:

Decimal - more

Sorry, i should actually check whether it's a number as opposed to just characters/number combo. Is there a way to do that? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229444 Archives:

RE: Decimal - more

That does the trick nicely, thank you! :) From: Adkins, Randy [EMAIL PROTECTED] Sent: Friday, January 13, 2006 9:08 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Decimal - more IsNumeric comes to mind. -Original Message- From: Stuart

SOT: Aqua Studio / Oracle

Hi guys, I don't know whether anyone has used Aqua Studio before but in case you have then maybe you can help. I am trying to create a field with an incremental ID.  I found this clever script: CREATE SEQUENCE supplier_seq     MINVALUE 1     START WITH 1     INCREMENT BY 1     CACHE 20;

Re: SOT: Aqua Studio / Oracle

Thanks for that Hatton.  I managed to get the query window open and put a query inside but seem to get some errors. CREATE SEQUENCE PATCHID     MINVALUE 1     MAXVALUE 999     START WITH 1     INCREMENT BY 1     CACHE 20; Do you know whether my sequence should have a

RE: M E R R Y C H R I S T M A S

Merry Christmas from me too, I am always getting invaluable help, time and time again. http://www.stuartkidd.com/_fileserver/Video/ChristmasMessage2005.wmv ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble

Array in a session

Hi guys, I'm getting java.object type error when i am calling a session variable. Is it possible to have an array stored in a session variable.  Here is my calling code: cfoutput   cfloop from=1 to=#ArrayLen(session.compsEntered)# index=i    Entered #i#: #session.compsEntered[i]#br   /cfloop

Random Numbers

Hi guys, I'm trying to write an app which will choose three random numbers for a competition based on how many etnries there are.  I'm having problems trying to work out a way not to choose the same number twice, is there a way to do that which will fit into my CFLOOP structure?  Or is there a

Random Numbers -Whoops!

Sorry, here is teh code I meant to give, not just the small bit from before: Hi guys, I'm trying to write an app which will choose three random numbers for a competition based on how many etnries there are.  I'm having problems trying to work out a way not to choose the same number twice, is

RE: Random Numbers

) -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 11:32 AM To: CF-Talk Subject: Random Numbers Hi guys, I'm trying to write an app which will choose three random numbers for a competition based on how many etnries there are.  I'm having

RE: Random Numbers

Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 11:32 AM To: CF-Talk Subject: Random Numbers Hi guys, I'm trying to write an app which will choose three random numbers for a competition based on how many etnries there are.  I'm having problems trying to work

RE: Random Numbers

# #orderdirection# :.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 11:32 AM To: CF-Talk Subject: Random Numbers Hi guys, I'm trying to write an app which will choose three

client variables IE problem

Hi, I'm forever having problems with users who use IE (and that's a huge lot of them).  If they log in with Firefox they are usually fine. I am using client variables, when they log in with their email and password I assign some client variables like:         !--- check password ---        

Running SESSION CLIENT together

Hi guys, Is it possible to run client and session variables together? I have been running client variables for a while but now am about to start using session.  Instead of changing all my client variables to session in one shot i'd like to make a gradual move but i noticed the following lines

RE: Running SESSION CLIENT together

. You don't need to switch applications. Second, what doesn't work? M!ke -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 9:12 AM To: CF-Talk Subject: Running SESSION CLIENT together Hi guys, Is it possible to run client and session variables

Constraining cfselect

Hi guys, Does anyone know how to constrain the amount of selections in a cfselect (multiple)? And more so especially in a flash form. Thanks, Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble

SQL

Hi guys, I have club events listed in a database. To make shorter work for promoters when they'd like to duplicate events is there a way to copy a row in ms-sql via CF and find the ID of that row? Thanks, Saturday ~|

Re: SQL

: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 27 November 2005 18:21 To: CF-Talk Subject: SQL Hi guys, I have club events listed in a database. To make shorter work for promoters when they'd like to duplicate events is there a way to copy a row in ms-sql via CF and find the ID

Before and after decimals.

Hi guys, I've got a number in one of my fields which has a decimal point. I want to pull everything from the left of the point so I can use that value separately for a drop down box for the £ value (pound sterling) and to the right for the pence select box. I'm just wondering what the

Re: Before and after decimals.

, and then the reverse for the pence. cheers, barneyb On 11/8/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a number in one of my fields which has a decimal point. I want to pull everything from the left of the point so I can use that value separately for a drop

Finding top ranked articles

Hi guys, Late last night in a matter of moments I found myself creating a table called tbl_020articleTopRanked . The idea was to do something similar to news stories where they display their 5 top-viewed articles (like at SMH: http://www.smh.com.au - at the bottom end of the page). So

Re: Xmlformat() ... well not formatting

I'm forever having problems with that type of thing. On my site club owners can enter their club details, venues etc and I feed it out via XML. I have stuff like this in it: event = replace(myQuery.eventName[ctr], , lt;, ALL); event = replace(event, , amp;, ALL);

Re: Finding top ranked articles

table called views. Create a stored proc or query that selects the article and then does an update. Update article_table set views = views + 1. Or something like that. Then no need to worry about space and scheduling a delete. -Original Message- From: Saturday (Stuart Kidd

Re: Finding top ranked articles

Yep, that worked a treat. I did a little changing to take in to account for time as my site is hosted in the US and i'm in the UK: cfquery name=MyQueryName datasource=user020 maxrows=5 SELECT articleID, COUNT(topRankedID) AS MyHits FROM tbl_020articleTopRanked WHERE DateViewed BETWEEN

SQL distinct

be gratefully appreciated. Thanks, Stuart Kidd ~| 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 with Logware today. Try

Re: [SPAM : 8.1] Re: ColdFusion Podcast Series | Tips, Tricks and News

Snake, here's a link to what Podcasting is: http://www.020.com/webs/02005/showArticle.cfm?id=234 On 2 Nov 2005, at 18:15, Snake wrote: What is a podcast anyway? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:22 To: CF-Talk Subject: [SPAM

Re: SQL distinct

persona ni utilizar el mismo en forma no autorizada. Dichas acciones están prohibidas y pueden ser consideradas ilegales. Si Ud. recibiese este email por error, por favor comuníquelo de inmediato al emisor del mismo. -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL

Find no records

Hi guys, Since getting help on my last problem which was finding records of users (from user table) which have events in the events table I am now trying to list all the users in the users table which don't have any rows which match in the events table. cfquery name=GetPromoters

Re: Find no records

, u.firstName, u.lastName, u.emailAddress, u.password FROM tbl_020publicUsers u WHERE u.userID NOT IN (SELECT DISTINCT userID FROM tbl_020eventDetails) On 11/2/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, Since getting help on my last problem which

Simple SQL

Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser,

Re: Simple SQL

tables in you're 'From' clause. rgds, Charlie Hanlon - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:49 AM Subject: Simple SQL Hi guys, I'm trying to do a simple query but am having

Re: Simple SQL

cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:59 AM Subject: Re: Simple SQL On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details

stop: SHOUTING

Hi guys, Just wondering if anyone knows a good way to recognise when all the characters are capitalised? Some users love putting text in CAPS and it just looks awful when it's displayed on screen. Any help I'd be grateful. Thanks, Saturday

Re: stop: SHOUTING

Thanks to everyone for their help on this. Via everyone's help i've now got a solution. :) On 24 Oct 2005, at 19:28, Kerry wrote: cfscript str=i HAVE MY CAPS LOCK ON BY MISTAKE!; ucasecount = len(rereplace(str,[^A-Z],,ALL)); lcasecount = len(rereplace(str,[^a-z],,ALL)); if(ucasecount gt

Moving directories via CF code

Hi guys, Does anyone know whether it's possible to move a directory and its contents to a different place without actually physically moving it via a shell command or dragging and dropping (on Windows). Is there a CF command to do it in my script or would that be a security problem? I have

Client variables

Hi guys, I have a competition on my site. When a user enters the competition I set a client variable: !--- set the client variable using the current article id --- cfset 'client.competitionEntry#url.ID#' = 1 I tested the competition a few days ago and now when i come to look at it I can

Coldfusion - i'm moving on

Hi guys, I'm quite happy with myself because after so long i've been using CF i haven't always been using it in 'rapid development'... but today instead of keep re-writing code, usually in a copy paste style then a re-hash of variable names etc I decided I was going to create an include

cftextarea p and br

Hi guys, I have a textarea in my form (Flash form) and I've noticed that if I make a paragraph break in my textarea the actual html comes out as two br's. The code i'm using to output my textarea is: cfoutput#Replace(GetArticle.articleMain,#chr(13)#,br,all)#/ cfoutput Does anyone know of

Getting a variable

Hi guys, I've got a simple question just can't find my answer. I want to dynamically define a variable. cfset evaluate('client.competitionEntry', '#url.ID#') = 1 So in the above case i would want to define, say cfset client.competitionEntry255 = 1 I'm sure this can be done easily i just

Re: Getting a variable

Certainly lots of ways to skin a cat. Thanks everyone! :) On 4 Oct 2005, at 20:35, Bryan Stevenson wrote: cfset client.competitionEntry#url.ID# = 1 not tested...should fly Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

Online quiz

Hi guys, I have 5 questions in my MS-SQL database and when i want to display them in an online quiz I loop them through like so: cfform cfoutput query=blah cfinput name=#questionID# value=answerID /cfoutput /cfform When these get submitted i look through my DB again to pull the

cfloop list

Hi guys, I've appended a list and on this occasion my list outputs 1,3,5 (for instance). cfloop list=incorrectList index=thisItem cfoutput#GetQuizQuestions.questionText[thisItem]# this wrong/cfoutput /cfloop The problem i'm coming across an error which

Re: cfloop list

oh! easy as that, thanks everyone for your replies :) Thanks! On 3 Oct 2005, at 22:23, Adrian Lynch wrote: Wack some #'s in there. list=#incorrentList# Ade -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 22:15 To: CF-Talk

INNER JOIN

Hi, I've been having trouble with JOINS. My query below works but when i try outputting my results I am getting duplicate authors (authorID). cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020authorDetails.authorFirstName,

Re: INNER JOIN

, Adrian Lynch wrote: A quick suggestion, write a test page with the minimum of code in. It'll make it easier for you to debug and easier for us to help. Ade -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 10:50 To: CF-Talk Subject

Re: INNER JOIN

Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 12:37 To: CF-Talk Subject: Re: INNER JOIN Hi, I've simplified it a bit: cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID

Now more query problems... boo hoo

Jumping from one query problem to another... just when it was safe to to run a query another problem leapt out of the dungeons. I would like to only pull the top 8 authors who have the most articles (articleID) I have specified only to get the 8 maxrows but the problem i'm having is when i

Re: Now more query problems... boo hoo

I did try to use COUNT(tbl_020articleDetails.articleID) AS totalArticles but came up with the error: [Macromedia][SQLServer JDBC Driver][SQLServer]Column 'tbl_020authorDetails.authorID' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP

Re: Now more query problems... boo hoo

I'm managed to do the GROUP BY stuff and it's not throwing any errors but when I add the COUNT() in the order it isn't doing anything: cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, tbl_020authorDetails.authorFirstName,

Re: Now more query problems... boo hoo

- Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, September 29, 2005 1:19 PM Subject: Now more query problems... boo hoo Jumping from one query problem to another... just when it was safe to to run a query another

restricting cfoutput character length

Hi, I'm trying to do something which i can imagine is very simple but can't find the function. When i display a title cfoutput#myTitle#/cfoutput i'd like to just display the first 15 characters and if more then put three dots (periods). I know the LEN function but i can't work out how

Re: restricting cfoutput character length

- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 8:42 AM To: CF-Talk Subject: RE: restricting cfoutput character length From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] I'm trying to do something which i can imagine is very simple but can't find

Order by number of articles (count?)

Hi guys, I'm trying to work out how to order my query by the amount of articles. cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe,

Re: Order by number of articles (count?)

) AS totalArticles !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 2:34 PM To: CF-Talk

Re: Order by number of articles (count?)

Hi Robert, When i tried your one I had this error coming up: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Column 'tbl_020authorDetails.authorID' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY

Queries oh queries

Hi, I'm trying to retrieve data from two tables in one query, when i was just querying one everything was okay: cfquery name=GetAuthors datasource=user020 SELECT authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe FROM

Re: Queries oh queries

(Stuart Kidd) [EMAIL PROTECTED] wrote: Hi, I'm trying to retrieve data from two tables in one query, when i was just querying one everything was okay: cfquery name=GetAuthors datasource=user020 SELECT authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe FROM

Re: Queries of queries

I'm not sure if it got posted as i got a reply saying there were over 100 lines in the email so: Hi, Thanks guys! I have given all replies a try but managed to get it done this way better... but it's only outputting 1 articleTitle and not the whole lot. Sorry that i didn't state my problem -

Splitting cfoutput of grouped query

I'm having some trouble trying to split a query. cfquery name=GetAuthors datasource=user020 SELECT tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe, tbl_020articleDetails.articleID, tbl_020articleDetails.authorID,

Re: Splitting cfoutput of grouped query

CFOUTPUT GROUPs, however, you usualy always need the simple CFOUTPUT to get the details. M!ke -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 1:31 PM To: CF-Talk Subject: Splitting cfoutput of grouped query I'm having

Re: Splitting cfoutput of grouped query

EQ 10 /div div /cfif /cfoutput On 9/27/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Mike, I've tried various ways, like having a cfloop within the simple cfoutput - but no luck. The code is: p cfoutput query=GetAuthors group=authorID Name: #authorFirstName# #authorSurname

Damn Queries!

Hi, I have a table named tbl_020articleFeatures which has fields featureID and featureName. I also have a table named tbl_020authorDetails which has authorID as a field (as well as other stuff). I made a 'cross table' which is called tbl_020authorFeatures - this table will have rows to

Re: Damn Queries!

FROM tbl_020authorFeatures, tbl_020articleFeatures WHERE authorID = #client.authorID# AND tbl_020articleFeatures.featureID = tbl_020authorFeatures.featureID /cfquery It seems to work :) On 25 Sep 2005, at 16:06, Saturday (Stuart Kidd) wrote: Hi, I have a table named

Re: Damn Queries!

ON ( f.FeatureID = j.FeatureID ) INNER JOIN tbl_020authorDetails a ON ( j.AuthorID = a.AuthorID ) WHERE a.AuthorID = #CLIENT.authorID# Ade -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: 25 September 2005 16:07 To: CF-Talk Subject: Damn Queries! Hi, I

loop list

Hi, Up until now I had a nice little loop list going. cfloop list=#GetArticle.articleLinks# index=myLink cfoutputa href=#myLink# class=contentarearight target=new#myLink#/abr/cfoutput /cfloop Now i have decided to have another field in my

DateTime problems

Hi, I'm inserting some user comments into a database. When done, they insert articleID, ipAddress and commentDate (the date when they were submitted). Before a comment gets added i check the database to see whether there already exists a comment from the same IP Address in the last 10

Re: DateTime problems

Boisvert wrote: It should be commentDate #dateAdd(n, -10, now())#. cheers, barneyb On 9/21/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi, I'm inserting some user comments into a database. When done, they insert articleID, ipAddress and commentDate (the date when they were

Re: DateTime problems

, a #createODBCDateTime()#. On 9/21/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi, I'm inserting some user comments into a database. When done, they insert articleID, ipAddress and commentDate (the date when they were submitted). Before a comment gets added i check the database to see

Re: DateTime problems

', not 'date'. JDBC calls dates 'date', calls times 'time', and calls datetimes, 'timestamp'. So cfqueryparam cfsqltype=cf_sql_timestamp value=#myDateTimeValue# /. cheers, barneyb On 9/21/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi Charlie, Yes, it holds date and time

SOT: Counties and Towns data for UK

Hi, Does such a place exist where you can download databases of counties and towns for the UK?  I'd like to use them for my multiple related selects. Thanks, Saturday ~| Discover CFTicket - The leading ColdFusion Help

Catching errors and emailing

Hi guys, Just wondering if anyone knows of a way of emailing any errors which are caught? So that way if there is an error I'll get to find out what it is as most users probably wouldn't bother emailing one if found. Thanks, Saturday

Re: Catching errors and emailing

Thanks for that. Can I ask why it's not a good idea to use CFTRY/CFCATCH? Whereabouts do i put the CFMAIL script below? It comes up with an error saying that TYPE is undefined in ERROR? Thanks, Saturday On 15 Jul 2005, at 14:06, Michael Dinowitz wrote: Sorry, forgot to mention that I

Re: Catching errors and emailing

: It is meant to be use in an error template. Check out the doc for cferror, which lets you specify a page to run when an error occurs. On 7/15/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Thanks for that. Can I ask why it's not a good idea to use CFTRY/CFCATCH? Whereabouts do i put

Join queries

Hi guys, I'm working on the search page of a dating application. In the form where the user gets to choose his/her preferred partner there are a few checkboxes which says: I am searching for: Love Casual Travel mate Friend When displayed as checkboxes i'm pulling from a table called

Re: Join queries

') and form.hasPhotograph eq 1 AND imageAuthorisation = 1/cfif AND p.profileid = a.profileid AND a.attributeid IN (cfqueryparam cf_sql_type=integer value=#form.attributeid# list=yes) ORDER by confirmationDate DESC /cfquery On 7/15/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys

Re: Join queries

Yeah, i remember now why i did that weird thing with the loop - i couldn't seem to get it to work. If I put the below in, the flash form will not load (although no error comes up either). cfloop query=FindRelationshipTypes cfinput

2 Primary Keys

Hi guys, I want to add a row in a join table which i don't want to be duplicated ever. So i have my tableID, table1ID, table2ID - if table1ID = 24 and table2ID = 35 i don't want there to ever be a reoccurence of them. I guess i have to set both of those fields (table1ID, table2ID) to

Re: 2 Primary Keys

Hi Jordan, Yes, more than one field needs to be a primary key. I'm using MS-SQL (on shared hosting). Stuart On 14 Jul 2005, at 23:07, Jordan Michaels wrote: Saturday (Stuart Kidd) wrote: Hi guys, I want to add a row in a join table which i don't want to be duplicated ever. So i

Re: 2 Primary Keys

but storing the link in a 1 to many or many to many db design. If table1 can only ever be linked to 1 table2 record and vice versa, wouldnt it be easier to store the table1ID in the table2 as a field (or vice versa)? All your queries would have 1 less join, etc. Aaron Saturday (Stuart Kidd) wrote

Re: 2 Primary Keys

Sorry if this has come through twice but i got a bounce back saying the email body was too long (so have deleted some now). My problem is that i have a form on a dating site where when users sign up i create a row for them in my profile table. When collating their profile I also ask them what

Re: 2 Primary Keys

Thanks Ian, that did the trick. Got it working. Cheers! :) On 15 Jul 2005, at 00:31, Ian Skinner wrote: Please feel free to fix the typos by removing the extra space after the pound sign on the second insert value and the missing right parenthesis ) to close the Values Caluse. Be

Re: 2 Primary Keys

Yeah, i was wondering whether i needed that field as i couldn't see how i'd use it. I'll go ahead and delete it. Thanks, Stuart On 15 Jul 2005, at 00:52, Dave Watts wrote: I want to add a row in a join table which i don't want to be duplicated ever. So i have my tableID, table1ID,

Re: 2 Primary Keys

Just one other thing however, how do i create the compound key via Enterprise Manager, can I do it through that? I'm on shared hosting with hostmysite.com. Thanks, Stuart On 15 Jul 2005, at 00:52, Dave Watts wrote: I want to add a row in a join table which i don't want to be duplicated

Re: 2 Primary Keys

. Run code run. Please! - Cynthia Dunning -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 4:51 PM To: CF-Talk Subject: Re: 2 Primary Keys Just one other thing however, how do i create the compound

Checkbox baby checkbox 123..

Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I then use it in a select statement. In my WHERE clause i put something like: WHERE gender = '#form.genderSeeking#' AND genderSeeking =

Re: Checkbox baby checkbox 123..

IN (cfqueryparam cfsqltype=cf_sql_integer list=yes value=#form.relationshipTypes#) On 7/7/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I've got a form which has 4 checkboxes - relationshipType1, relationshipType2, relationshipType3 and relationshipType4. Getting this information I

Developer's edition of MS-SQL with CFMX7

Hi, I have my site hosted remotely with CFMX7 and MS-SQL.  At home I have the free devleoper's edition of CFMX7 and am wondering if there is any such free developer's edition of MS-SQL?  Is there anyway I can test my code at home with my database, either remotely or with another free type of

Re: Developer's edition of MS-SQL with CFMX7

-Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 05 July 2005 11:54 To: CF-Talk Subject: Developer's edition of MS-SQL with CFMX7 Hi, I have my site hosted remotely with CFMX7 and MS-SQL. At home I have the free devleoper's edition of CFMX7 and am wondering

CF connecting to datasource problem (SQL)

Hi guys, I've set up a servder in sql called mytest and have the sql server running in my services.  I am having a problem connecting the datasource in CF Administrator. The error i'm getting back is: Connection verification failed for data source: user020 java.sql.SQLException:

CFX_JpegResize caching problem

Hi guys, I'm using the CFX_JpegResize tag and seem to be having a caching problem. My destination is the same as my source, i'm just overwriting the image. cfx_jpegresize action = resize source = #KissMyDateImages##GetProfileDetails.imageName#

cfqueryparam

Hi, Just wondering if my CFQUERYPARAM is correct... should I be also putting cfqueryparam tags around the SET variables? !--- update user details to DB --- CFQUERY NAME=UpdateUserDetails datasource=user020 UPDATE

OT: Internet Law / Privacy Policies / European Law

Hi guys, I've created a dating site, nothing flash however (apart from Flash Forms!), kind of simple. It's going to be free for people to use and will run on alongside a site of mine which is already reasonably popular. The dating application let's users correspond with total anonymity in

Mac Widgets

Hi guys, Probably a very stupid question but... Does anyone know whether it's possible to make a widget out of a CF app using CF7? Thanks, Stuart ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket

cffile and Flash Forms

Hi guys, Does anyone know whether it's possible to have a cfinput type=file name=myImage in a Flash Form? I'm coming across some problems. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time

Re: cffile and Flash Forms

Bryan, Doing it that way however won't keep the image details in that one same form though will it? It' would be two separate ones right? Saturday On 2 Jun 2005, at 23:12, Bryan Stevenson wrote: Do it in a regular HTML pop-up window that is opened from within Flash Bryan Stevenson

  1   2   3   >