Maybe this? Loop around the
INSERT INTO Table
(Field)
VALUES ('#theQuery.FieldValue#')
At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
wasgr ;-)
>
>Thanks
>
>Bryan Stevenson
>VP & Direct
Hi kay,
one other thing, if you want to configure your SQL server for trusted
connections or otherwise, go to Enterprise Manager, select Properties of the
server and click on Security tab. Select either Windows (for trusted) or
SQLServer+Windows (for either) as your connection type.
HTH
andy
Hi Kay,
Check your ODBC configuration on your client machine, as it might be that,
rather than the SQL Server config.
The SQL Server ODBC driver may be configured to use "With Windows
Authentication" and you can change this to "With SQL Server authentication"
Alternatively, if you do need to use T
Hi all,
Our development environment has CF4.5 and SQL Server 2K on an SBS2K
machine on a LAN. Some of my clients are on CF5 hosting, and there are
some features of CF5 I would like use for these clients. I have the
Developers edition of CF5 on my Win2K machine, and I would like it to
connect to d
are there plans to include support for recursive structures or pointers in
upcoming WDDX specification revisions? my suggestion for doing so would be
the inclusion of a simple new element in the DTD: something along the lines
of 'pointer' or 'structPointer'.
here's the modification to the WDDX D
Hello. I mentioned a few days ago that we've been developing CF-based DNS
management. I am looking for a small group of beta program participants.
If you are interested, read on, otherwise please disregard this message.
If you are interested:
Please fill out the following form:
http://www.brai
On 2/6/02, <[EMAIL PROTECTED]> penned:
>Hi, does anyone here have any experience with the Linkpoint Cold Fusion tag.
>
>Their documentation is really poor and I can't figure out:
>
>1. Precisely how you define the total amount for a transaction that does not
>have any shipping or tax info involved
Is there any reason your is inside the pair and not
outside?
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
> OK..long day..CF whining about syntax...help!
>
> The situation:
>
> CF doesn't like my syntax for this bit of looping over a query to
> insert muliple reco
Thanks Jamesthat trick worked like a charm!
There is one bad record throwing the whole lot.
Thanks all for your help ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
---
You may have to do the loop on the outside of the query, use a
cftransaction to send them all through at once.
INSERT INTO Table
(
Field
)
VALUES
(
dang tried the semi-colon already with no luck...thought that's what it
wasgr ;-)
Thanks
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia
Oh nevermind, your not looping over the columns of the query (long day
as well)
I think you need a semi-colon at the end of your query, since that will
put multiple inserts in one cfquery.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Mes
Nope that's not the issue for sure..just used the single quotes as an example..but
thanks ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associa
Are there
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 8:01 PM
To: CF-Talk
Try taking out the tags and output the loop to the screen
surrounded with
Then just check your SQL statements... It's usually standing out like a sore
th
Hmmm, well if one of your fields is numeric, then that wouldn't work,
since numeric values don't need 's around them, you could use the
isNumeric() function for that.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Bryan
and yes I did actually close the CFLOOP properly in my real code ;-)
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.
OK..long day..CF whining about syntax...help!
The situation:
CF doesn't like my syntax for this bit of looping over a query to insert muliple
records. It's
complaining about the final ")" closing bracket for the insert. Any ideas? I'm sure
I've done it
beforejust saw it posted the other
yes, the best solution is to store the date and time in separate fields
if you are able to do so. you would then use the createodbcdate and
createodbctime functions for your inserts. your sql statement would
read: "select * from classes where classdate in (select classdate from
classes where i
Dave,
Someone else here posted this JavaScript code for checking the file type
within the browser. This combined with server side checking validation
should help prevent people from uploading the wrong file type. I use it for
all my image upload routines. The customers like being warned before
That is the question...given a class ID, how do you make a query that
selects all other classes on that same day (but at different times)?
Formatting dates for output display is not the question, but how to speci
fy
just the date portion of the date/time field in the query itself.
SELECT * FROM
I normally am reluctant to deploy client-side Java applets as part of a
larger application... too many problems with security, cross-
browser/platform compatibility, portability, performance, etc.
However, sometimes i need to include things like wp, ss, image
manipulation or draw capability.
you can store the time/date data in one field and make a view/query breaking
out the separate parts into 2 new fields..
- j
-Original Message-
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 6:32 PM
To: CF-Talk
Subject: Re: Formatting a Date in MS SQL Acces
Thanks for the response and tips.
Are you suggesting I use a date and a time column in my classes db?
With several classes per day, they each have a time of day. I was trying to
be efficient and use a single date/time field to store this info. The trick
then becomes how to find records with the
Hi, does anyone here have any experience with the Linkpoint Cold Fusion tag.
Their documentation is really poor and I can't figure out:
1. Precisely how you define the total amount for a transaction that does not
have any shipping or tax info involved.
2. Which field provides the result of the
We are currently getting an inordinant amount of restarts as well. We also see
alot (over 10,000) i/o errors a day due to clients not waiting for a response from
our bogged down oracle 8i database server. We also recieved over 7,000 timeouts
even after bumping the timeout up to 45 second and still
I was just going to suggest this but had already deleted the previous
messages. You said that the employee does not want to display their
picture, so you must know this from somewhere in the database, right? Use
that to decide if you even need to check for the file in the first
place...
> Is it n
This is headed in the right direction I think.
It doesn't take into accound the sub-query I was after.
I know the ID of the class. I want all classes on the same day as the ID
'd
class.
Each class date has DATE and TIME info in the same field. Your approach
gets around that limitation but I'm no
Hi list,
I have just enabled ColdFusion performance monitoring on an CF 4.5.2
enterprise box. I have restarted the cf-service.
But I cannot see any activities on one of the 11 counters
(DB-AVG-DB-Time/msec, AVG-Queue-Time/msec,Bytes IN/Sec etc..
The diagramm lines stay on a zero line although I kn
On 2/6/02, Bruce Holm penned:
>BTW, when I created the date in Access, I specified the Date format to be
>General which stores date and time info in the SAME field.
BTW Bruce. Access always stores dates as date and time. So does SQL
Server. When you choose type of date/time when creating the fie
At 11:20 AM 1/9/02, Dimo wrote:
>I thought the problem could be somewhere along this line, but wasn't
>sure, since IE and NN 6.2 process the page with a normal speed. I'll try
>to decrease the number of tables... geez, 18 tables... did I really need
>that many of them? :)
Almost never. It's bet
Is it necessary to use OS-level file permissions to keep those photos from
being shown? I don't know what else you do with these files, but if it's
only your CF app accessing and displaying them, you could keep a simple
boolean field within a database table that tells you whether or not to show
t
On 2/6/02, Bruce Holm penned:
>You missed some key info I mentioned. Access stores dates as date and ti
>me
>(1/6/2002 1:57:00 PM).
>In my table are classes for the same day, but at different times.
>What I want my query to find (and maybe what wasn't clear) is all classes
>for a given date (just
Chris,
I'm alread using the ACCEPT attribute in the CFFILE tag. However, if you try
and upload a non-GIF file to the server, you get a standard CF error page.
What I was hoping to do was to trap the problem and specifically know that
it was a bad file type as opposed to another error and re-di
Thanks, that worked.
Ray
At 02:25 PM 2/6/2002 -0800, you wrote:
>Maybe try to CFFILE COPY, to a temp area, is successful display the image,
>if not dontThe you can CFFILE DELETE to clean up the temp.
>
>Adrian
>
>-Original Message-
>From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
>Sent:
You'll have to put spaces between each letter of the text that way
though.
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Michael Corrigan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 5:25 PM
To: CF-Talk
That's a good idea. maybe if you play with it, you could get it to wrap
itself in a column by restricting the column width (i.e -Original Message-
> From: Jeff Brown [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 4:00 PM
> To: CF-Talk
> Subject: Vertical Text
Nope.
- j
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 4:52 PM
To: CF-Talk
Subject: Re: CF Server / SQL 2K / IIS
> Is it necessary for IIS to be running on the SQL Server if our webserver
is
> a totally separate machine?
No
_
Can you use tables? You could create a single column of cells with a
letter in each.
> -Original Message-
> From: Jeff Brown [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 4:00 PM
> To: CF-Talk
> Subject: Vertical Text
>
>
>
> Any ideas on how I might display text
Maybe try to CFFILE COPY, to a temp area, is successful display the image,
if not dontThe you can CFFILE DELETE to clean up the temp.
Adrian
-Original Message-
From: Ray Bujarski [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 1:59 PM
To: CF-Talk
Subject: Roadblock!! fi
> Is it necessary for IIS to be running on the SQL Server if our webserver is
> a totally separate machine?
No
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $9
You missed some key info I mentioned. Access stores dates as date and ti
me
(1/6/2002 1:57:00 PM).
In my table are classes for the same day, but at different times.
What I want my query to find (and maybe what wasn't clear) is all classes
for a given date (just the date part, not the time, otherw
I am trying to display a image of employees belonging to a director.
Some of the images exists, some of them don't, some of the images exist
without read permissions due to the employee not wanting their picture shown.
How can test the permissions of this file? FileExist(/photo/11.jpg)
returns
I've got it now--if you want to see the answer it is at
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadi=
261933
I'm sorry for doing a double post, but it was one of those times when I
needed input quickly.
-Original Message-
From: Janine Jakim
Sent: Wednesday
Java
-Original Message-
From: Jeff Brown [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 3:00 PM
To: CF-Talk
Subject: Vertical Text
Any ideas on how I might display text vertically using either CF or CSS?
Without stacking the letters using 's and without creating graphics
It seems that wrapping the email address in <> works.
Jamie
On Wed, 6 Feb 2002 10:47:57 -0500, in cf-talk you wrote:
>I've got a user whose email address is:
>firstname.o'[EMAIL PROTECTED]
>
>I've seen a lot of email addresses, and have never seen an apostrophe in
one
>before, but most email c
Hello Adam
On Wed, 6 Feb 2002, at 09:05:44 you carefully wrote:
CA> DON'T deny them access, there IS a much better way. Subtly identify them (by
CA> IP, cookie, whatever you're doing), and then sporadically generate false
CA> errors throughout the system. Create odd, database errors or just str
Sorry I messed up the subject line on my last mail
Anyone ever have fileexists return a false yes? I get a true returned,
stating the file does in fact exist however when I browse to this file, it
isn't there? Anyone have any ideas on this?
#fileexists("/prj/photos/GIF/72.90.8.color/#ph_num#.
> You need to refer to the pages table twice (once for children c and
once
> for parents p)
Brilliant. Table aliases were hovering at the edge of my
awareness whispering "We can do it!", but obviously
not loud enough for me ;)
thanks,
- Gyrus
- [EMAIL PROTECTED]
wo
Any ideas on how I might display text vertically using either CF or CSS?
Without stacking the letters using 's and without creating graphics.
The text displayed vertically will be dynamic... it's looking like it might
not be possible...? Thanks!
v/r, Jeff
FAQ: http://www.thenetprofits.co.uk/col
Anyone ever have fileexists return a false yes? I get a true returned,
stating the file does in fact exist however when I browse to this file, it
isn't there? Anyone have any ideas on this?
#fileexists("/prj/photos/GIF/72.90.8.color/#ph_num#.jpg")#
You need to refer to the pages table twice (once for children c and once
for parents p)
SELECT c.pageID, c.fulltitle, p.fulltitle AS parenttitle
FROM pages c, pages p
WHERE c.parentID = p.pageID
> The table, called 'pages', has the following basic fields:
>
> pageID (PK)
> fullTitle
> parentI
Yeah her server logs are full of network I/O errors and she has been
using single threaded sessions. I think once she gets that handled it
will all be peaches and cream.
There are two major products that come out of Berkeley: LSD and [Unix]
BSD. We don't believe this to be a coincidence.
perhaps i'm oversimplifying, but can't you use the
ACCEPT="mime_type/file_type"
attribute of CFFILE in the upload?
christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PRO
> I actually tried outputting the CFCATCH.type, and it just
> gives me an "UNKNOWN". Also, it does not fail silently; it
> generates a CF error page, which is why I was looking to
> trap it.
>
> My ultimate goal was to trap the bad file type error, and
> re-direct back to the calling page ale
In my experience, manually locking all memory variables, and handling all e
rrors (cftry/catch) are the biggest fixes for server restarts or freezes.
Chris Norloff
-- Original Message --
from: Jennifer Knoblock <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTE
I posted recently about how to define a relationship in
Access where the PK for a FK field is actually in the same
table. I've sorted that, but getting the query right is
another matter...
The table, called 'pages', has the following basic fields:
pageID (PK)
fullTitle
parentID (FK - pageID of p
Jim Vosika wrote:
>
> Using CFHTTP or any other sort of tags, can you grab the affiliate login
> page, fill in the user name and password forms and then submit the form
> (assuming you knew the form names so CF could populate them and
> execute)?
Yes.
> Then once logged on you could have
Fred jambukeswaran wrote:
> I am trying to convert the value 54545 to an array that looks like
> MyArray[1] = 5
> MyArray[2] = 4
> MyArray[3] = 5
> MyArray[4] = 4
> MyArray[5] = 5...
>
> If there a better way then looping over the length of the string and
> populating the array?
string = RERe
Try this:
The only problem is that the file must complete the upload process, which
could be a pain...
- j
.
jim.curran
technical.director
nylon.technology
six.west.fourteenth.street
new.york.ny.10011
212.691.1134
[EMAIL PROTECTED]
..
-
The only way to do this is by code, look at the file scope and see what
extension was passed. Now I would also like to point out that the Pc
uses extension, the Mac doesn't so I am not sure if you'll need to read
the file and check it for these users, or train them to use extensions.
-Origin
> I would like to trap a CFFILE error using CFTRY/CFCATCH if
> the user submits a bad file type. I only want to allow them
> to upload .gif files.
>
> I can use the CFCATCH TYPE="Any" to trap it, but I was hoping
> that I could trap specifically for a bad file type.
>
> I noticed that there a
I would like to trap a CFFILE error using CFTRY/CFCATCH if the user submits
a bad file type. I only want to allow them to upload .gif files.
I can use the CFCATCH TYPE="Any" to trap it, but I was hoping that I could
trap specifically for a bad file type.
I noticed that there are a whole slew o
The only way that I can thing of is to loop over the string, unless you
separate the string by delimiters, to make it a list, then use
ListToArray()
__
steve oliver
atnet solutions, inc.
http://www.atnetsolutions.com
-Original Message-
From: Fred jambukeswara
I am trying to convert the value 54545 to an array that looks like
MyArray[1] = 5
MyArray[2] = 4
MyArray[3] = 5
MyArray[4] = 4
MyArray[5] = 5...
If there a better way then looping over the length of the string and
populating the array?
Thanks,
-Fred
_
Oh, on the SELECT Email, My_ID take out the EMail, and replace it with a
DISTINCT I do not think this is the best way to do the query but it
should be a quick(i.e. dirty) method to get the results.
Snipe -
On Wed, 6 Feb 2002, Tyler Silcox wrote:
> I just tried this out and it still does the
Try these. They should work:
SELECT ltrim(rtrim(Email)) AS Email, MIN(My_id) AS My_Id, MIN(MyDisplay) As
MyDisplay,
MIN(MyPassword) as MyPassword
FROM EmailAccts
GROUP BY ltrim(rtrim(Email))
If My_Id is the primary key for the EmailAccts Table:
SELECT ltrim(rtrim(Email)) As Email, My_i
>can you remove the duplicates?
nope, I've got to keep em.
>t-SQL has no way to confirm which one you WANT to keep
I guess that's what I learned from this little experimentthanks for the
help guys->
Tyler Silcox
email | [EMAIL PROTECTED]
- Original Message -
From: "Christopher Oli
the problem is, t-SQL has no way to confirm which one you WANT to keep.
you can pull the distinct email addresses easily enough, but there's
going to have to be some other intervention to tell it WHICH set of data
associated with the addresses to use.
can you remove the duplicates?
christopher o
I just tried this out and it still does the same thing. It looks like it
grabs the distinct emails in the subquery (which is good), but then it
returns 4 rows for that email in the main query if they exists...almost
there. I could rig it up if I wanted to, and just grab the distinct emails,
and
Erik Volden posted this one a while back. Best one I have tried so far.
.good..
.bad..
__
Why Share?
Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Set
Perhaps it's not because of your hardware setup. Perhaps it's because
you're a pain in the ass. :-) I didn't ask, and I got an invitation.
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 11:12 AM
To: CF-Talk
Subject: RE: Bug in CF 5's
I'd like to grab all of the distinct emails, and then return the rest of the
columns once per unique email. So if there were 2 [EMAIL PROTECTED]
in the table, but the rest of the row data was different, I'd like to just
grab the first (or last, it really doesn't matter) row of data when the
query
you may want to use some javascript to check the email address before
sending it to the server: