RE: [ cf-dev ] soEditor

2003-09-12 Thread Alex Skinner
how about checking the cgi scope browser variable to see if its netscape and if it is you know it has come from a textarea not soeditor. or If you can do it in javascript then set a hidden field value to either textarea or richeditor depending on what is being shown ?? my 2p Alex

RE: [ cf-dev ] soEditor

2003-09-12 Thread duncan . cumming
yeah, could do, but that's not enough. e.g. IE on a Mac it displays the textarea, but IE on the PC displays the soEditor. So I could test to see if it's IE, but I'd need to know the OS too. this code is happening *before* the form gets submitted, as it's working out what values to insert into

RE: [ cf-dev ] soEditor

2003-09-12 Thread Rich Wild
cgi.http_user_agent usually contains an OS identifier also. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 10:02 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] soEditor yeah, could do, but that's not enough. e.g. IE on a Mac it

[ cf-dev ] OT: SQL server constraint question

2003-09-12 Thread Justin MacCarthy
Hi all, In SQL server 7, I got the TABLES [ACLPrincipleID] ACLPrincipleID [pk] [autonumber] ACLUser [ACLPermission] ACLPrincipleID [ck][fk ACLPrincipleID.ACLPrincipleID] ACLPermissionID [ck][fk ACLPrinciplePermission.ACLPermissionID] [ACLPrinciplePermission] ACLPermissionID

RE: [ cf-dev ] OT: SQL server constraint question

2003-09-12 Thread Robertson-Ravo, Neil (RX)
Well, The problems I can see straightawat is that your ACLPersmission table does not have a PK itself (even as a lookup table, it should have one). Your schema is not normalised in that you have explicitly tied both the ACLprincipleID to both tables, therefore you cannot insert a record in your

RE: [ cf-dev ] OT: SQL server constraint question

2003-09-12 Thread Snake Hollywood
Integrety is there for a reason, ignoring it would be the same as not having it. You have to insert data in the correct order to adhere to the integrety and relationships. ACLPrinciplePermission ACLPrincipleID ACLPermission Is the order that will not break any constraints. Russ Michaels

[ cf-dev ] Help again....

2003-09-12 Thread Paul_Swingewood
Ok so I have sorted out its the case thats not working.. When the query returns all the Report Types the case is looking for the word PANDA in there. Do I need any wild cars or does case look at all values in the list ??? Or. Maybe its because the value keeps getting set each time the

[ cf-dev ] Help!!!!

2003-09-12 Thread Paul_Swingewood
Er Too much coding today for my brain . I am trying to optimise some code and have lost the plot completely. I need the code to return all the report types Panda, Plasc, KS2, etc etc. The user then clicks on the report type and by now a collection of information has been passed

RE: [ cf-dev ] OT: SQL server constraint question

2003-09-12 Thread Justin
The ACLPermission table has a Compound PK (ACLPrincipleID ACLPermissionID ) The reason for this design is becuase there is a ACLRole table as well so.. [ACLRole] [ACLPrinciple] PK PK

[ cf-dev ] ValueList

2003-09-12 Thread Adrian Lynch
Isn't ValueList() a bloody great function? I've always known about it but never really used it. Isn't CF great :OD -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency

Re: [ cf-dev ] ValueList

2003-09-12 Thread Ian Westbrook
Isn't CF great :OD yep. best thing since html itself, IMHO... Ian W -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency --

RE: [ cf-dev ] Help again....

2003-09-12 Thread Snake Hollywood
Why no use the NOCASE functions ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 15:03 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Help again Ok so I have sorted out its the case thats not working.. When the query

RE: [ cf-dev ] ValueList

2003-09-12 Thread Snake Hollywood
Don't forget quotedvaluelist() -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 16:27 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] ValueList Isn't ValueList() a bloody great function? I've always known about it but never really used

RE: [ cf-dev ] ValueList

2003-09-12 Thread Adrian Lynch
Even better! -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:00 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] ValueList Don't forget quotedvaluelist() -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 12

Re: [ cf-dev ] ValueList

2003-09-12 Thread Damian Watson
and great-two-for-the-price-of-oneValueList() - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:18 PM Subject: RE: [ cf-dev ] ValueList Even better! -Original Message- From: Snake Hollywood [mailto:[EMAIL

RE: [ cf-dev ] ValueList

2003-09-12 Thread Snake Hollywood
Go change your password damian -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 12 September 2003 17:30 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] ValueList and great-two-for-the-price-of-oneValueList() - Original Message - From: Adrian