Re: CSv

Comma separated values. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Jim Taylor [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date:

Re: Re-visiting Print() function

Here's a sample print button.. SCRIPT LANGUAGE="JavaScript" !-- Begin if (window.print) { document.write('form' + 'input type=button name=print value="Click to Print This Page" ' + 'onClick="javascript:window.print()"/form'); } // End -- /script At 10:09 AM 8/11/2000 -0400, you wrote: I

RE: CSv

Comma-Separated Values file. Basically just a representation of the DB tables using commas to separate the values. Jason Web Application Developer webworld studios, inc. -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 12:18 PM To: [EMAIL

Monitoring Sessions

Is there any way to monitor the number of sessions for a CFapplication? And is there a way to see how much time is left in a Session? Thanks Chad -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To

RE: CSv

Comma Separated Values. --K -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 9:18 AM To: [EMAIL PROTECTED] Subject: CSv what is a csv file? -- Archives:

Insert produces blank record

Using an Access table, I have a template with an INSERT and a MAX(ID), plus a CFLOCATION routine within a CFTRANSACTION. I've tried it with both SQL INSERT and CFINSERT and, either way, the autonumber field is incremented, but no data is inserted in the record. If I use either insert method on

another newbie confused about session management

Hi! I've been reading the posts on session management, and sadly, I am still utterly confused. What compounds my confusion is the fact that I am using session management in conjunction with an Oracle stored procedure. I must admit, I'm over my head here--BIG time. Scenario: I have several

Re: Need your help desperately

Hey, check this out! This guy is now Spamming people and trying to make himself not look like such a blatant cheater any more. He must read CF-Talk! dilip jumani wrote: Hi. I hope you are fine and enjoying best of your health. I request you to please share your experience of Cold Fusion

Re: CSv

back in the old days we called em comma delimited test Same thing i guess (nust be another new standard!!) - Original Message - From: "Jamie Keane" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 9:50 AM Subject: Re: CSv Comma separated values. -- Jamie

RE: From .exe to .dll

If the program is relatively small it is relatively simple to convert it to a DLL. It is easiest if you have the CFX Wizard that will install into Visual Studio when you install CF on the machine.. Alternatively if you are having errors getting the wizard to install I could mail it to you off

RE: CSv

what is a csv file? Comma Separated Variable It's basically a simple text file that has commas between the fields, and (usually) has quotes around the text entries (so that commas are remembered) To see one, save a spreadsheet from Excel or a database from Access into CSV and open the result

Select Distinct not so distinct

Hi all, I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field, names from table where type = foo" -this returns every field where type is a match. SQL="select

RE: Select Distinct not so distinct

when you select distinct(name), foo, bar, baz ... it returns all the distinct combinations of the selected fields. Chris Olive, DOEHRS Website Administrator -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 1:48 PM To: [EMAIL PROTECTED]

RE: Database problems

Katrina Chapman To: [EMAIL PROTECTED]

CFX_NNTP and Formatting

I'm using the CFX_NNTP tag from www.fuseware.com. Using the GetMessages Action, the output give the following variables from the newsgroup message headers: MessageID From Subject Date References Byte Count Line Count I've never built a newsgroup or

Re: Need your help desperately

Karl, I don't see a single specific question. All of them are of a general nature. I consider myself honest and would have no problem either asking or answering questions of this type. I don't know the whole context of this message, so I may have missed something, but based on the words alone,

RE: CSv

Comma-separated values file. Same as a comma-delimited file, basically. "value1.1","value1.2","value1.3"[cr][lf] "value2.1","value2.2","value2.3"[cr][lf] etc Some apps that produce csv files don't--or don't always--use the double- quotes. This is okay if the data doesn't have any embedded

Accessing COM Objects Remotely

Hello, I am starting a project where I need to access some COM objects located on a "remote" machine. It's not really remote, it's on the same LAN as the CF server. I have spent the last hour searching the list and Allaire forums and reading all the books, but I can't seem to find enough

password protection

'lo all, I have a directory that holds administrative pages for my client database, and need to secure it (obviously). What is the best way to go about doing that so that one cannot call the modules in that directly, circumventing and /login module... --

RE: Error Handling

Hi, TRhanks I did a find on the cfcatch.detail and I got what I wanted. Thanks a lot. -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:21 AM To: [EMAIL PROTECTED] Subject: Re: Error Handling Miriam, If you put only the CFSEARCH

RE: Database problems

You most likely want the cflocation outside the cftransaction. CF is probably never hitting the closing cftransaction tag and therefore is doing a rollback of the insert. Just a guess, but makes sense. I think. :) Dan -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]]

RE: CSv

comma-separated values eg. "field1","field2","field3","field4","field5" - Steve Steve Pierce, HDL "Co-Location starting $99 per month, no setup fee" (734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.com -Original Message- From: Jim Taylor [mailto:[EMAIL PROTECTED]] Sent:

Re: Documentation system a la Perldoc

No, but if you write one, I'll use it g.. Seriously, it wouldn't be that hard to write one. Just wrap doc items in an "extended" quote like !--- @[header] something profound @ ---. You could use cffile and regular expressions to suck them out. I am assuming that perldoc is like javadoc.

RE: Select Distinct not so distinct

The problem with select distinct is if you're select more than one column at a time. It will return distinct ROWS. Not just the one column you specify. --K -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:48 AM To: [EMAIL PROTECTED]

Getting a file's size

Hi, How do I get a file's size from the server? Is CFDIRECTORY with the List action the way to do it, or is there a more efficient/direct way to get a file's size? Thanks, Dave -- Archives:

Re: CSv

BTW, it's a lot quicker to go to something like AskJeeves and type in CSV into the box - it'll give you links to most things I garee sorry , just their was a lot of metion about it this AM - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: Database problems

Try This. cftransaction cfquery datasource="county" insert into LINKS (APPROVE, TYPE_DESC, MAIN_NBR, LINK) values ('#form.APPROVE#', '#form.TYPE_DESC#', '#form.MAIN_NBR#', '#form.LINK#') /cfquery cfquery

RE: Select Distinct not so distinct

If any of the remaining fields are numeric you can use SELECT DISTINCT name, sum(foo) AS foo, sum(bar) AS bar ..., and that will narrow down the combinations. Marianne Daye Programmer/Analyst -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Friday,

Re: password protection

Several approaches the way Isee it, depends on application design: 1) Secure by using the operating system and NTFS ACL's, use a CFX tag that can interact with Windows NT security to modify privileges as you see fit, while this is trickier than any other, the security achieved is probably some

RE: I need a host. Intermedia testimonials

I've successfully hosted multiple domains at www.corpsite.com both for personal sites as well as business ones. Great guys and a good tech team that are quick to get any issues resolved. Eric [EMAIL PROTECTED] 08/08/00 01:28PM Try that again, I just got into their web site a min ago.

Re: password protection

Here's what I do. Its kind of a roundabout way, but it works for me: on loign create a session variable. in the application .cfm file do the following: cfif not isDefined("Session.sessionStarted") cfset notLoggedIn="true" /cfif cfif isDefined("notLoggedIn") cfset

Re: Re-visiting Print() function

How could you modify the script below so that it only prints the FRAME? Is that possible? Thanks, Erika - Original Message - From: "Frank Priest" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 10:50 AM Subject: Re: Re-visiting Print() function : Here's a

URI Encoding in CF?

Is there a way to do a URI Encoding in cold fusion? I need to be able to exchange values of ?,,@, etc. in a passed url to HEX values. (ex. an needs to be %26 ) Advance thanks, --aimee -- Archives:

OT: user interface resources/groups

can anyone suggest any user interface focused websites or user groups? i'm interested in researching application standards like: - button naming (Save or Submit? Edit or Modify?) - button placement (Save before Cancel or Cancel before Save?) - current trends (tabbed, explorer-like menus,

File name with query string in JS function

This is a variation on the recent thread where we discussed using link references like page.cfm?foo=bar#spot. In a framed environment, I have four JS functions that use rollovers to populate another frame using syntax like: function loadfn() { parent.empl_list.location =

RE: URI Encoding in CF?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 URLEncodedFormat() (Not to be rude or nasty, but other people's copies of CF came with documentation, right? It wasn't just a fluke that a got a set of printed docs? Then there's always the electronic form on the website) Best regards, Zac

RE: URI Encoding in CF?

Thanks for the function and the RTFM prompting. URLEncodedFormat() (Not to be rude or nasty, but other people's copies of CF came with documentation, right? It wasn't just a fluke that a got a set of printed docs? Then there's always the electronic form on the website) Best regards,

SQL Question (sorta OT)

Hi all Here the query I'm trying to edit: CFQUERY NAME="LookUpResults" DATASOURCE="WebData" SELECT CompanyName, City, State, CompanyURI FROM Main (Index=ix_Main_CompanyURI) WHERE CompanyURI IN (#QuotedValueList(CompanyNameSearch.Custom1)#) ORDER BY CompanyName /CFQUERY I would like

RE: Getting a file's size

I wrote: How do I get a file's size from the server? Is CFDIRECTORY with the List action the way to do it, or is there a more efficient/direct way to get a file's size? To clarify, I'm trying to get a list of file sizes from the server (not after they've been uploaded by the user). Using

RE: Newbie Question - Creating Data Source for CSV text file

html font size=3Look at the CFML Reference on CFHTTP.br br It appears that you can use CFHTTP to create a query based on a CSV file.br br br At 08:55 AM 8/11/00 -0700, paul smith wrote:br blockquote type=cite citeIn my app at a href="http://bradford.support.net/"

Remote SQL server as datasource

Hi Folks, I am trying to set a remote MS SQL server (via the internet) as an ODBC datasource in ColdFusion 4.x. I can get the connection going fine in the ODBC control panel. But in the ColdFusion administrator the datasource verification fails. Does anyone have any ideas of what could be

Adding numbers to a select box... urgent

I'm in a bind here, I have to add 4 0's to a select box if the "Sub-account" does not exist, otherwise, just use the sub-account. Here's the code: OPTION VALUE="#trim(GetAcctInfo.Account)##trim(GetAcctInfo.sub_account)#"#trim(Get AcctInfo.Account)##rtrim(""GetAcctInfo.sub_account,

Re: SQL Question (sorta OT)

John, You should be able to say: AND NOT omit = 'yes' That's assuming that omit is a text field and not a boolean (yes/no) field. If its boolean you could just say: AND omit = false hth, Kevin At 01:33 PM 8/11/00 -0700, you wrote: Hi all Here the query I'm trying to edit: CFQUERY

Query Results stored in Application Variable

If you store a query result in an application variable how do you refer to individual records to be displayed in cfoutput query="application.MyQuery"? Is it the same as a regular query? Sebastian -- Archives:

Re: randrange() function

On 8/11/00, Seth Petry-Johnson penned: I wrote a little test. I ran a loop 1000 times, each iteration generating a random number using the randRange() parameters you mentioned above. On 5 separate page loads, ALL 1000 numbers were less than 1,736,483,927. If I dropped the second parameter to a

Re: Remote SQL server as datasource

Make sure that you that you have input your SQL Server username and Password in the ColdFusion Login section under CF Settings. Unless you do this, ColdFusion does not know how to log into the server and you will have to pass the username and password as part of the attributes of CFQUERY.

Page Breaks

Is it possible to do a page break or a Page eject between forms. We are currently using: h1 style="page-break-before: always"h1 This seems to work in netscapre but not IE. -- Archives:

RE: Query Results stored in Application Variable

Application.myquery.fieldname :-) -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:25 PM To: [EMAIL PROTECTED] Subject: Query Results stored in Application Variable If you store a query result in an application variable

RE: Adding numbers to a select box... urgent

You are adding the "" to the display and not to the value. -Original Message- From: Marc Lippman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:20 PM To: [EMAIL PROTECTED] Subject: Adding numbers to a select box... urgent I'm in a bind here, I have to add 4 0's to

RE: Adding numbers to a select box... urgent

Thanks anyway guys, figured it out. -M -Original Message- From: Marc Lippman [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 5:20 PM To: [EMAIL PROTECTED] Subject: Adding numbers to a select box... urgent I'm in a bind here, I have to add 4 0's to a select box if the

Re: Remote SQL server as datasource

Thanks for your help, unfortuantely, I have done that, but still no-go...It still comes back with a "FAILED" status for the connection in the ColdFusion Admin ODBC settings. Eron - Original Message - From: "[EMAIL PROTECTED]" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August

CFFILE in multiserver setup?

Greetings all, Briefly, does the destination attribute of CFFILE have to be a directory on the same server that is running Cold Fusion? Less briefly, can I specify that a file upload, the template for which is served by the CF server on machine A, occurs to a directory on machine B (which is

RE: Custom Nesting Tag

I am trying to write a complex custom tag that does paged output of a query: CF_OutputPage query="myquery" startrow=1 maxrows=10 ...stuff with #myquery.column# ... /CF_OutputPage !--- returns: outputpage.numpages, outputpage.thispage, outputpage.prevstart, outputpage.nextstart --- The easiest

RE: Custom Nesting Tag

How about during the end context of the custom tag you try this: cfoutput query=""#attributes.query#"" startrow=#attributes.startrow# maxrows=#attributes.maxrows# ThisTag.GeneratedContent /cfoutput I am still unsure about what you are doing here, but you cannot split an opening and closing tag

Re: Remote SQL server as datasource

Go into the Windows NT "Control Panel", "ODBC" Select your data source, click configure, click "Nex", "Client Configuration" Make sure that you have TCPIP selected under Client Libraries. Hopefully that will do the job :-) At 06:05 PM 8/11/2000 -0400, you wrote: Thanks for your help,

Re: More elegant way of passing URL variables?

Justin, I'd love to learn more about these tags. Do you have a url? Also, if your tag could replace the ?, then would the encryption make the url spider safe? Thanks, Rick - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11,

Re: Remote SQL server as datasource

Hi Frank, That was also already done, still no go (although from ODBC control panel the source tests out fine--its just ColdFusion that can't seem to get to this SQL Server datasource...weird.) Thanks for your help... Eron - Original Message - From: "Frank Priest" [EMAIL PROTECTED]

RE: Custom Nesting Tag

This is better than what I had, but still doesn't work. #ThisTag.GeneratedContent# doesn't substitute the variables, so I get the unsubstituted variables: trtd#UserName#/tdtd#UserType#/tdtd#Email# /td/tr #Evaluate(ThisTag.GeneratedContent)# generates an error which I dont understand: An

Re: Working with a string...

Gary: I would do a Find on the string for the @ and then a Mid function that starts at 1 and ends at the position returned from the find function. Andrew Hewitt Web Application Developer webworld studios inc. - Original Message - From: "Gary McNeel, Jr." [EMAIL PROTECTED] To:

Re: CFFILE in multiserver setup?

There are a number of ways you could do this; it wouldn't be necessary to have CF on both machines necessarily. For example, you could have the user upload to a temp directory on machine A via CFFILE. Your CF template could then FTP the files to their proper location on the UNIX box. Depending on

RE: Working with a string...

I have an email address sting that I need to manipulate. I need to just get the first part before the @ symbol and discard the rest (although knowing how to grab it might be useful too). Is the only way to do a regular expression? Nope. It's easy: cfset justTheUser =

Re: Remote SQL server as datasource

Have you tried using an IP Address instead of a server name in the CF administrator? One more thing to check is the login permissions... Try connecting as "sa" That was also already done, still no go (although from ODBC control panel the source tests out fine--its just ColdFusion that

Announcing: CF_OUTPUTPG (thank you everyone)

Just to thank everyone on this mailing list (and especially Justin Kidman who helped me with this) I present for your dissecting pleasure: CF_OUTPUTPG.cfm I wrote this module both because I needed it and as an exercise in writing my first custom tag. It works the same as CFOUTPUT

RE: Remote SQL server as datasource

I recently had this problem. Once I created a new user login in SQL Server and NT for the web server and used that login in cf admin, I was fine. Make sure you have port 1433 open on the database machine for TCP/IP and double check the database name. Good luck. Sincerely, Shane Witbeck

Queries

This is a multi-part message in MIME format. --=_NextPart_000_0102_01C003E4.9D6F5580 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 2 Questions. 1. Just curious, is it possible to do a query across two different = datasources? I have a

Re: Announcing: CF_OUTPUTPG - the example file

Sorry - any of you with HTML based email didn't see the source code, you saw the OUTPUT (kind-of) Here again is the example file: pre !--- // Testpg.cfm // Peter Theobald 8/10/2000 // [EMAIL PROTECTED] // // This file is a simple example of using the CF_OUTPUTPG module // Make sure

Re: Announcing: CF_OUTPUTPG - the example file

test - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 11, 2000 10:42 PM Subject: Re: Announcing: CF_OUTPUTPG - the example file Sorry - any of you with HTML based email didn't see the source code, you saw the OUTPUT (kind-of)

Re: CFTHROW

Miriam Hirschman wrote: How Do I define my own error in a cfthrow? I would like to say if the error is an invalid search criteria then Try something like this: CFTRY CFIF SearchCriteria IS Invalid CFTHROW TYPE="MyCustomError" MESSAGE="Your Search Criteria are Invalid"

Documentation system a la Perldoc

Is there some equivalent tool such as perldoc for Cold Fusion? If you don't know what it is, it's an embedded language containing documentation on a page. Paul -- Archives:

Re: Documentation system a la Perldoc

There is : FuseDoc , you can find it at Hals page @ http://www.teamallaire.com/hhidev/index.cfm?external=true Justin Maccarthy - Original Message - From: "Paul Johnston" [EMAIL PROTECTED] To: "Fusebox" [EMAIL PROTECTED]; "Cf-Talk" [EMAIL PROTECTED] Sent: Friday, August 11, 2000 5:31

<    1   2