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:
#CFCATCH.Message#
Basically the idea is to wrap the CFTHROW in conditional code so that it cr
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)
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:
select UserName, UserType, Email
from Users
This is a test of custom tag CF_OUTPUTPG.
UserTypeEmail
#UserName##UserType##Email#
PR
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
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
Webmaster
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 QUERY="queryna
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 ca
> 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:
-Ron
-
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
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: "Cf-T
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:
#UserName##UserType##Email#
#Evaluate(ThisTag.GeneratedContent)# generates an error which I dont understand:
An error has occurred while
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]>
T
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,
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, unfo
How about during the end context of the custom tag you try this:
ThisTag.GeneratedContent
I am still unsure about what you are doing here, but you cannot split an
opening and closing tag between two seperate CFIF statements, it is not
allowed in CF.
Justin Kidman
-Original Message-
F
I am trying to write a complex custom tag that does paged output of a query:
...stuff with #myquery.column# ...
The easiest way is the following:
If ExecutionMode is 'start', calculate number of pages, prevstart, nextstart, etc.
return those in caller.outputpage.#var#, and somehow "spit out
> 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?
Wouldn't JavaScript be the best way to go? It would have to make its own
counter.
--
tmp will then have everything before the @
Justin Kidman
-Original Message-
From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 4:06 PM
To: Cf-Talk
Subject: Working with a string...
I have an email address sting that I need to manipulate.
I need to just g
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?
Ex. [EMAIL PROTECTED] would become gmcneel (maybe in a variable).
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 n
You say: ... stuff...
Justin Kidman
-Original Message-
From: Peter Theobald [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 2:54 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Custom Nesting Tag
I'm creating a custom tag that has a start and end, ie: ...
stuff...
I
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, Aug
I'm creating a custom tag that has a start and end, ie: ... stuff...
In the tag I test ThisTag.ExecutionMode to see if I should be handling the start or
end processing.
Here's my question:
I MUCH prefer to use the explicit syntax: than the
syntax because it's faster and clearer. However I
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 "Sub-acco
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
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
Is it possible to do a page break or a Page eject between forms.
We are currently using:
This seems to work in netscapre but not IE.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscrib
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.
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
If you store a query result in an application variable how do you refer to
individual records to be displayed in
?
Is it the same as a regular query?
Sebastian
--
Archives: http://www.mail-archive.com/cf-talk@houseo
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:
>
>
> SELEC
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:
#trim(Get
AcctInfo.Account)##rtrim(""&GetAcctInfo.sub_account, 4)#
Right now, it doesn't work.
Any guru's out there have an idea?
Marc
--
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 wrong
Look at the CFML Reference on CFHTTP.
It appears that you can use CFHTTP to create a query based on a CSV
file.
At 08:55 AM 8/11/00 -0700, paul smith wrote:
In my app at
http://bradford.support.net/"
eudora="autourl">http://bradford.support.net/
I had my client
export their jobs database to C
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
Hi all
Here the query I'm trying to edit:
SELECT CompanyName, City, State, CompanyURI
FROM Main (Index=ix_Main_CompanyURI)
WHERE CompanyURI IN (#QuotedValueList(CompanyNameSearch.Custom1)#)
ORDER BY CompanyName
I would like to add "omit <> 'yes' " to the WHERE clause. When I do this
>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 r
You might start at www.useit.com and www.asktog.com. Also a newsgroup,
comp.human-factors.
-Original Message-
From: Mike Amburn [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 3:45 PM
To: Cf-Talk; ACFUG
Subject: OT: user interface resources/groups
can anyone suggest any user i
-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 Be
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 = "alpha_fn.cfm
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, et
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: http://www.mail-a
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 sa
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:
- Original Message -
From: "Jon Tillman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Frida
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 ag
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
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, Au
Try This.
insert into LINKS
(APPROVE,
TYPE_DESC,
MAIN_NBR,
LINK)
values
('#form.APPROVE#',
'#form.TYPE_DESC#',
'#form.MAIN_NBR#',
'#form.LINK#')
select max(record) as newrecord
from links
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:
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: http://www.mail-archive.com
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]
Su
No, but if you write one, I'll use it ..
Seriously, it wouldn't be that hard to write one. Just wrap doc items in
an "extended" quote like . You
could use and regular expressions to suck them out.
I am assuming that perldoc is like javadoc.
Cary
At 05:31 PM 8/11/2000 +0100, you wrote:
>Is
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: Friday,
You most likely want the outside the . CF is
probably never hitting the closing 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]]
Sent: Friday, August 11, 2000 10:57 AM
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 code
'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...
--
*
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 inform
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
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 com
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, I
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 for
Katrina
Chapman To: [EMAIL PROTECTED]
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]
S
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 dis
> 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
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 lis
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.
>
> --
> Ja
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
> F
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 s
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 it
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: http://www.
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 Uns
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 PROTE
Here's a sample print button..
At 10:09 AM 8/11/2000 -0400, you wrote:
>I have found that even with a s
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]>
Dat
Can we see some code? You may be nesting your tags incorrectly.
--K
-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 5:00 AM
To: CF-Talk
Subject: Database problems
I have a strange problem with inserts in an Access table. I can't seem
to wr
How Do I define my own error in a cfthrow? I would like to say if the error
is an invalid search criteria then
Thanks,
---miriam
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscr
The wizard and header file can be found here with directions of where to
place them
on your hard drive with VC++ 6. It requires that CF server is installed on
the same
box but might be hackable if you manually add the reg keys noted in the
instructions.
http://members.home.com/hoffmanj/cf/cfx_f
Art,
Keep in mind how session variables work. The variables are stored in
the web server's memory and the timeout period tells the server to
clear them if there is no activity for THAT session for the specified
time.
The obvious question here is: "If the web is stateless how can the
server know
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: http://www.mail-archive.com/cf-talk@houseoffu
If you use the pips , ensure that you change your ODBC driver settings, a
comma is default.
BTW if you looking to play around, check out the IE Databinding stuff with
CSV file.
6 Lines of code and you can output the file sort it by columns and allsorts
of cool stuff. Handy for a quick csv viewin
Thanks! That works perfectly!
Cody
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 4:02 AM
Subject: RE: Problem carrying over form values.
> > You can try replacing the " with some string you know the person will
I'm assuming that you're having some type of summary list to select from
that takes you to the details page (or something like that)...
I've had the same issue, I have done some weird things to keep this all in a
single form and evaluate the numerous form fields passed to come up with the
one id t
Encrypt the url
I wrote a couple of tags that encrypt/ decrypt query_strings
so instead of index.cfm?value=6&name=jim
You get
page2.cfm?94946560A4946560B495214551E01031C1D1A.
and on page2 you include
and you can still use url.value and url.name etc
I don't have it handy at the moment t
David's right, just use CFCATCH.Detail in a CFIF statement and you can catch the
detail down to the very fine point. Lemme know if ya need anything else.
Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/11 7:21 AM >>>
Miriam,
If you pu
what is a csv file?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED]
P.S. Jeremy, don't forget to those session variables ;)
Todd Ashworth
- Original Message -
From: "Ricq Pattay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 11, 2000 11:24 AM
Subject: Re: CF Query Problem with Session Variables
| Try:
|
|
|
|
| SELECT User_ID, Ful
Hey everyone,
If you are caching queries, is there a way to force CF to flush them?
When an administrator updates a table, I would like CF to dump any cached
queries using that table, so that users aren't viewing old data.
Dana Larose
Web Developer
Canadian Web Design & Consulting Inc.
A: 701-
[EMAIL PROTECTED] wrote:
> I looked a bit into that , but I waant a message only for that error, and
> it doesn't seem like I can tell CFTRY to only catch the cfsearch error.
> Please tell me if I am wrong.
I've just started using CFTRY myself, but check out CFTHROW. It's my
understanding you
What I do is put all pages that need to be password protected into their own
folder. Then I toss an application.cfm into that folder that looks
something like this:
This application.cfm includes all of the attributes of the root
application.cfm, but also checks for your session varia
This is a multi-part message in MIME format.
--=_NextPart_000_0046_01C0038B.89E6DDC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Can somebody help me?
This problem occures sporadically. It seem to happens when there's a few
user using the system.
parse into a database once received?
From: "John McKown" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: "CF_Talk" <[EMAIL PROTECTED]>
Subject: Newbie Question - Creating Data Source for CSV text file
Date: Fri, 11 Aug 2000 10:28:04 -0400
CF Gurus,
I have a customer that is a car dealershi
In my app at http://bradford.support.net/ I had my client
export their jobs database to CSV using a pipe (|) as a field
delimiter to get around the quotes problem. They also
upload their CSV using HTTP.
best, paul
At 04:22 PM 8/11/00 +0100, you wrote:
>Remember also that quotes screw up CSV fil
Thanks for all of the feedback.
Keep it coming...
Right now I am learning to use CFHTTP...
Couldn't I just use that to take their CSV and insert it into a table?
Or am I going to have issues when they have strings that contain quotes?
Thanks in advance...
John McKown, VP of Business Services
D
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> You can use CSV files for ODBC datasource, but don't! The main reason is
> that ODBC holds onto sources like that once it's got them
>
> Make a link table in Access which talks to the CSV - this is the much
> preferred solution as you
If your server is NT you can create an ODBC connection using the Microsoft
Text Driver (txt and csv). I've experimented with it just a bit and it
seems to work on very simple things. I would think that you'd want to weigh
how many steps you want to take manipulating and moving data. If the csv
Yes, I forgot this in my earlier post. Same here. And they sent
a tech to install the new HD (many of their systems come with
on-site service).
best, paul
At 10:45 AM 8/11/00 -0400, you wrote:
>support (at least I don't think they do?). I only had to call support one
>time, 30 second hold ti
Hi,
I am dynamically generating a list of customers, on which a user can click
to go to a detailed page. To do this, I am putting the customerID into a URL
variable in the A HREF path. But the client doesn't want to see the value in
the address bar, as they consider it a security risk.
What woul
I've done it. It's tricky, but I had to go into the NTServer control panel
and define a DSN there. Once that was done, the CF Administrator could see
it and configure it for ColdFusion. (We have a partner site FTP 6 csv
files into our server every night so we always have up todate informatio
The permissions are in the database and trying to do
it at display time (I understand this as doing it
while displaying it on the browser) may not be the
best way to do it.
> Kedar Desai
> Differential Technologies
> Fairfax, VA
--- "Olive, Christopher M Mr NMR"
<[EMAIL PROTECTED]> wrote:
> why
1 - 100 of 180 matches
Mail list logo