Re: Database/CF easy problem for someone.

2001-05-14 Thread j p
I assume "I want it on one line" means the output...???(correct?) Try this...(putting the output loop inside the tags) #NumberFormat(getDeptR.cono,'___')# #getDeptR.Coname# #getDeptR.Firstname# #getDeptR.Firstname# #getDeptR.Firstname# #getDeptR.Firstname#

Crystal Reports rehash

2001-05-10 Thread j p
I hate to rehash this, but I have gone through the archives and cannot find what I need. I am trying to pass parameters to a crystal report, example - last name: if the HTML for last name is left blank I don't wantit as part of the crystal filter, if someone put something in the fieldI want to

RE and testing a list for items other than...

2001-04-05 Thread j p
Hello all, I need the RE for seeing if a list ONLY contains 1/multiples of four allowable options. For instance, the allowable options are "jane,tom,sally,mark" you pass me a list. "Jane,tom,mark" or "Tom,Sally" or "Jane" all of these are OK you pass me a list. "jane,allisa,tom" this is

Studio Project Deployment - Help

2001-02-23 Thread j p
Has anyone EVER been successful in getting CF Studio Projects to 'deploy' either directly or via scripts... If so please help me out..I keep getting "No Deployment Path specified" for every sub-folder, even though I specify create new folders. jp ~

RE: Quick Reference for all standard variable scopes?

2001-02-19 Thread j p
>does anyone know of an FAQ or somesuch that contains a list > of all available standard variable scopes? > ie. > File.ServerFile > Session.CFID > Session.CFToken > etc. Here's what I've compiled over time. Variables. (local - server memory) Request. (local - server memory) 'queryname'.

Re: dates as long ints

2001-02-02 Thread j p
thout issue... --Scott - Original Message - From: "j p" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 9:36 AM Subject: dates as long ints > > I recall seeing this subject here in the past and can't turn

dates as long ints

2001-02-02 Thread j p
I recall seeing this subject here in the past and can't turn up anything in the docs. Does anyone know how to cast a date value into a long interger, and what format that takes. So {ts 2000-12-02 14:23:03} would come out as 20001202142303 I don't know if that is the exact output but somethin

URGENT: getting return value from Stored Proc....HELP

2001-01-30 Thread j p
URGENT: getting return value from Stored ProcHELP Happy new year - all, I have an hair puller (for me)... I need a return value from a stored proceedure, to use later in a template relocation. I can seem to get it toe work... I have tried the Cfquery/EXEC the Cfquery/Call and have decided

Scope question

2001-01-15 Thread j p
Does anyone have a breakdown of how variables are stored by CF?? i.e. Session and application scoped are stored in a structure, is this true of ALL scopes?? form. url. etc.. If not ..where and in what storage 'medium'?? Variables. Request. 'queryname'. Cfquery. Form. Url. Session. Application.

TWO for the crew

2000-12-04 Thread j p
1) Will CF conect to a mdb DS through a network connection?? If I map a dreve to a network machiene and try to connect using that drive letter in the CFA ODBC connection screen - it doesn't seem to like that?? Has anyone done this successfully? How? 2) The application.cfm template is used on

carriage return question

2000-12-01 Thread j p
carriage return question: Is it possible to use carriage returns to seperate a list??? For instance: In a form text area, if a series of lines get submitted, I want to use it as a list... This code is NOT working me: #Session.Methods# I would expect a comma delimited list... Any help???

CFFILE - writing a CF template REDUX

2000-11-30 Thread j p
Maybe I mis-communicated my delima, here it is in code... I want to write a CF template using CFFILE - I know what the template will look like, but need some variables resolved. The only way I have foud to work is: 1) Set var to the entire contents of the page 2) use the < > " to replace these

CFFILE - writing a CF template woes

2000-11-29 Thread j p
Hey Gurus, I need help on this one I am having problems getting CFFILE to write a cf template... The < > " and probably some otherthings are causing some wierdness. I have tried Replace(), Evaluate(DE()) to no end... How does one create a new CF template with CFFILE??? Someone had mentioned c

Studio: am I missing something

2000-11-28 Thread j p
doing a find and replace on a remote server (remote RDS or FTP) is it possible? _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com ~~ Str

CF Encode - (Howie Hamlin??)

2000-11-17 Thread j p
Hey a while back someone had a cfencoder application that helped with encoding files...I thought it was Howie. Does any one remember this - or have it?? I want to encrypt cfm files only... it is going through and doing all the files. I've tried *.cfm but it comes back as "can't find *.cfm" H

RegEx help PLEASE hurry...

2000-11-15 Thread j p
Hello all I have a page of text that looks like this... H e l l o A l l I want to condense it to... Hello All (getting rid of one space following every character) I know I can do it with regEx in studio replace pane... but I don't know the syntax... Anyone, Anyone, Beuhler??? TIA jp _

Clear Studio Cache

2000-10-27 Thread j p
What are the keyboard shortcuts for clearing studios cache??? CRTL + ALT + C + S ( I though - not working ) JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, cr

Re: Validate Multiple docs MORE

2000-10-26 Thread j p
Using STUDIO - it is possible to validate a page (for syntax), Is there a way to do this validation on multiple pages, say across an entire project...??? jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotm

Validate Multiple docs

2000-10-25 Thread j p
Can you use CF Studio to validate multiple pages?? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. ---

Login logic...

2000-10-25 Thread j p
I have a request that a user be returned to the page from wence they came - if they get rerouted to a log in screen (due to timeing out)... Or in lue of that, if a user is on a page, and they time out, then click on a link...Is there a way to use that "clicked on" link as teh destination afte

Array Sort [help][please]

2000-10-24 Thread j p
Hello All... I am trying to sort a multi-dimentional array. And am getting an error I've never seen before. The Setup I am querying two tables to populate a select box,Because I need to know which table the selection came from, and there will be duplicate IDs on two tables, I want t

RE: Expand Select Box -- Take Two

2000-10-17 Thread j p
;function clearBlanks() { > document.something.whatever.options[0] = null; > document.something.whatever.options[0] = null; > return true; >} > >In the body tag call the function onLoad="clearBlanks() >-Original Message- >From: j p [mailto:[EMAIL PROTECTED]] &g

Expand Select Box (JS Question)

2000-10-17 Thread j p
Is It possible through JS to expand a select box, I need to expand a select box when someone clicks on something (not the little arrow if the select box) JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.ho

charactersets...in Netscape

2000-10-10 Thread j p
This piece of code allows me to make sure teh browser is displaying Arabic...(IE) This doesn't work in NN...not only that there doesn't seem to be a supported Arabic font set in NN...does anyone know of an international release that supports Arabic and / or a meta tag that will allow me to f

Re: Experience with 'nvarchar' and foriegn languages stored in db

2000-10-09 Thread j p
Administrator >Softitler Net, Inc. >www.softitler.com >[EMAIL PROTECTED] > >- Original Message - >From: "j p" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, October 09, 2000 1:54 PM >Subject: Experience with &#x

Experience with 'nvarchar' and foriegn languages stored in db

2000-10-09 Thread j p
Does anyone out there have experience with foriegn languages being stored in a db, specifically Arabic,Katakana,Kanji or any other 2bit font language - stored n a n 'nvarchar' field. I am getting this type of output. ÇáÃÑÏä ÇáÇãÇÑÇÊ ÇáÈÍÑíä ÊæäÓ It is srored in the db like this (I think)...ant

UNIX odbc ini file details

2000-10-09 Thread j p
Can anyone give me an example of the unix odbc ini file - a copy of a real on would be preferable with an explanation of what the representation is... thanks J _ Get Your Private, Free E-mail from MSN Hotmail at http://www.

Urgent Help needed!

2000-10-06 Thread j p
I have never had a problem inserting null values into a db table that accepted null values before this. This below data chokes at the first NON-text blamk comma. The rub - it's a money field (SQL 7) and I can't use ''. Any ideas... 'Alda','Update','','ALDA','','',132860.0,0.48,0.45,0.45,0.4

Re: Going Insane...IIF (answer)

2000-10-06 Thread j p
OK OK found it..needed a NULL #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE('NULL'))# >From: "j p" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Going Insan

Going Insane...IIF

2000-10-06 Thread j p
Shouldn't these do the same thing (IIF more effeciently)...IIF is bombing I have tried it w/ and w/o the delayed eval DE()... #IIF(Len(conv_data.BankingSpecificLoansDeposits), conv_data.BankingSpecificLoansDeposits, DE(''))# #conv_data.BankingSpecificRating#'' ERROR- An error occurred w

Does cftransaction return anything??

2000-10-04 Thread j p
I need to be able to tell if the transaction block rolled back or committed...is there a way to do this??? Programatically NOT by looking in the db. JP _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.

cftransaction failed notification

2000-10-04 Thread j p
Is there a way to know (programatically - not looking at the db) if the queries in a cftransaction were successful? Does cftransaction return a failed code??? If not - does cftry/catch offer a way of knowing if the inserts were completed??? THX

OT: Math Question

2000-10-03 Thread j p
To the great CF masses... I need a math formula that will tell me what 'X' is. Example: 75 is 80% of X 100 is 25% of X Any mathmaticians out there... jp _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotma

DSN locking options...(2)

2000-10-03 Thread j p
Changing from excel to Access isn't an option, this is syndicated info provided in excel. However - you make it sound like Access can 'automatically' link to an excel file, and that access file can be used as the DSN...can you explain this a little better. No caching no where. >From: "Greg

DSN locking options...HELP

2000-10-03 Thread j p
Hello All, I am connecting to an Excel SS as a datasource, and I need to upload a fresh SS file once a day, the problem arises on the upload...The file (by the same name) uploads without throwing an error (using CFFTP to do so) BUT any queries to the DS return the OLD data...If I go into the C

File Compare

2000-10-02 Thread j p
Dose anyone have a good way to do a file compare??? (via CF) _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.ms