fat chance, we had a blast in the basement
many mm people, many developers from this list, and cfc list...it was
killer.
the party rocked..
and paul, may I never see you dance :) PLEASEE!
-Original Message-
From: Burns, John [mailto:[EMAIL PROTECTED]
Sent: Thursday, March
As far as I know, whatever the maxid is at the time you will get next MaxID +1. However if you are deleting the last record and then adding a new one, In SQLServer you will get the following.
ID Value
1 a
2 b
3 c
4 d
ID Value
1 a
2 b
3 c
4 d --Remove
ID
Do your insert - and then do a select looking for a record matching several
of the fields you just inserted. Doing a max(id) isn't 100% sure w/out
transactional processing. But if you select on several fields that you
*know* are unique... or at least, take the top record while sorting by the
id
On Thu, 2004-03-11 at 10:02, Burns, John wrote:
> I know this came up last week or so, but I believe the answer came for a
> mySQL database. I need a way in MS SQL to get the last inserted record
> via CF. I have a query inserting a row into the table with an
> auto-increment ID. I need to insert
But won't it eventually come back in and fill in some of those ones that
were previously deleted? As in your example, at some point won't
another item get assigned the value of 4?
John Burns
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1
Not a SQL Server guy, but can't you use @@IDENTITY. I believe there are
three different forms, which do slightly different things (global last
identity, connection last identity, and database last identity, or something
like that). Check the docs.
Cheers,
barneyb
> -Original Message-
>
On Thu, 2004-03-11 at 10:16, Burns, John wrote:
> But won't it eventually come back in and fill in some of those ones that
> were previously deleted? As in your example, at some point won't
> another item get assigned the value of 4?
MSSQL servers identity columns just keep going untill it they fi
A friend of mine asked me an interesting technical question for which I
have no answer, so I figured i'd ask the group.
If someone pops up a new window (assume MSIE 5/6+), is there any way to
specify the icon to use for the window itself instead of the blue "ie"
icon? Even if by some sort of
After reading the other responses, I have often selected the identity back
out, but you can also use a trigger if you're sticking to MS SQL. This is
my preferred way of dealing with this.
-Original Message-
From: Burns, John [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:
Kevin,
>Looks good to me. Satisfies the "did it do it?", "did it do it right?", and
>"what do I do next?" questions quite nicely.
- Great thanks... I want to make this very user friendly to the customers.
>Just a couple little things I noticed though:
>1. On the customer registration page, th
Jedit (http://jedit.org/) does split screen. See Joshua Miller's site
at http://www.joshuasmiller.com/jedit/ for info on macros and plugins
to emulate some of the bu8ilt-in functionality of Dreamweaver/Homesite.
I've been using it a while. It's not bad, the code insight provided
through the XML
> >2. You could possibly streamline the address information. There's a
> customer
> >address, ship to address, and billing address. You ask if the ship to is
> the
> >same as the customer addy, but don't ask the same for the billing.
>
>
> - Hmmm not sure what you mean here. Are you talking about m
People & Conference was good.
City = the suck.
I was able to convince Rachel that Devcon 2001 & 2002 in Orlando was a somewhat substitue for a vacation since we had Disney and Epcot around the corner.
However, that argument didnt work out too well with SLC.
-Adam
> -Original Message-
>
Be carefull using @@IDENTITY, as it can return erroneous information (especially if your tables have triggers associated with them). If you are using SQL Server 2000, use the SCOPE_IDENTITY() function instead of @@IDENTITY.
Cheers,
Jeff Garza
- Original Message -
From: Rob
To: C
From: "Jeff Garza" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 11, 2004 1:35 PM
Subject: Re: Reliable way to get ID of inserted record
> Be carefull using @@IDENTITY, as it can return erroneous information
(especially if your tables have triggers associated with the
On Thu, 2004-03-11 at 10:35, Jeff Garza wrote:
> Be carefull using @@IDENTITY, as it can return erroneous information (especially if your tables have triggers associated with them). If you are using SQL Server 2000, use the SCOPE_IDENTITY() function instead of @@IDENTITY.
It doesnt return erroneo
btw scope_identity() is not supported in SqlServer 7.
--
Rob <[EMAIL PROTECTED]>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Just keep in mind that it's platform specific. PC at work and Mac at
home will cost you a new license. :(
ken
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 10:52 AM
To: CF-Talk
Subject: RE: Piggyback question to: Transferring Dreamweaver Sit
But at the point where it does flip around, when you grabbed max() that
would no longer be the newest one right?
John
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:33 PM
To: CF-Talk
Subject: RE: Reliable way to get ID of inserted record
On Thu,
That'd be a hack in IE itself that I think you'd have to run on the
machine with IE installed and I'm fairly sure you're probably not
allowed.
John
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:25 PM
To: CF-Talk
Subject: Slightly OT
Oh come on, you could say you were visiting a ghost town right?
John
-Original Message-
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 1:34 PM
To: CF-Talk
Subject: Re: MAX 2k4
People & Conference was good.
City = the suck.
I was able to convince Rachel t
On Thu, 2004-03-11 at 10:51, Burns, John wrote:
> But at the point where it does flip around, when you grabbed max() that
> would no longer be the newest one right?
Yes. That is correct. You might want to double check me on that behavoir
(I dont have access to ms docs at the moment, but I did some
In IE 5+, you can use something called an HTA (HTML Application) that
allows you to specify an icon.
Here's an example (taken from MSDN library):
APPLICATIONNAME="myApp"
BORDER="thin"
BORDERSTYLE="normal"
CAPTION="yes"
ICON="graphics/face01.ico"
MAXIMIZEBUTTON="yes"
MINIMIZ
I just went to that site and it sure does look very nice. However, I
saw something that has always been a pet peeve of mine with regard to
ecommerce sites.
Lets say you walk into a store. Any brick/mortar one will do. You then
browse for merchandise, pick a few things up and walk up to your
reg
Hi All, I'm looking for a Web Based Email client as nice as this Perl
one at http://www.webbasedemail.com/. If I can't find a CF
implementation as nice I'm going to be forced to buy a Perl application.
And that is not cool. :-|
Anyone know of one? I wanted to get my hands on FuseMail but they
SET NOCOUNT ON
DECLARE @lastID BIGINT
-- Do your insert here.
INSERT INTO TEST
(foo)
VALUES
('hello')
-- This gets the value of the row you just inserted
SET @lastID = SCOPE_IDENTITY()
SET NOCOUNT OFF
-- Return back to CF.
SELECT @lastID AS lastID
#bar.lastID#
- Original Message -
I'll try to take that well.
Paul Kenney
WebMaster, CorporateWarriors.com
916-663-1963
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 10:14 AM
To: CF-Talk
Subject: RE: MAX 2k4
fat chance, we had a blast in the basement
many mm people, man
Ok...
Have many strings... vary in size I want them all to disaply from
character 1 to chracter 70. If tehre is less tehn 70 then nothing
happens, if there is more then 70 then trim all text remaining to the
right...
I am burnt today so I would love a little bit of help
Thanks
Kristopher
Hello all,
Does anyone know of there are any things that have come up in MX that
would disallow auto-filling PDF forms?
I did the tutorial here:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg32040.html
And everything was gravy until I got to the part where the PDF is
supposed to load
If the string is longer than 70 chars, it'll just return the first 70 chars.
If the string is less than 70 chars, it'll return the entire string.
-Original Message-
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 2:49 PM
To: CF-Talk
Subject: String Help
#left(string,70)# ??
Ryan
- Original Message -
From: Kristopher Pilles
To: CF-Talk
Sent: Thursday, March 11, 2004 1:49 PM
Subject: String Help
Ok...
Have many strings... vary in size I want them all to disaply from
character 1 to chracter 70. If tehre is less teh
left(string, 70)
- Original Message -
From: "Kristopher Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 11, 2004 12:49 PM
Subject: String Help
> Ok...
>
> Have many strings... vary in size I want them all to disaply from
> character 1 to chracter
> From: Kristopher Pilles
>
> Have many strings... vary in size I want them all to
> disaply from character 1 to chracter 70. If tehre is less
> tehn 70 then nothing happens, if there is more then 70 then
> trim all text remaining to the right...
Left(String,70)
If there's less than 70,
I think that Rob nailed it in the posting right after yours. This is only an issue where you have a trigger that inserts into a different table that has an IDENTITY field in it. In that case, @@IDENTITY will return the inserted ID from the trigger rather than your your original insert. Also, as
THANKS
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 3:18 PM
To: CF-Talk
Subject: RE: String Help
> From: Kristopher Pilles
>
> Have many strings... vary in size I want them all to
> disaply from character 1 to chracter
- Original Message -
From: "Bryan F. Hogan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 11, 2004 2:23 PM
Subject: OT: CF Mail Interface Needed
> Hi All, I'm looking for a Web Based Email client as nice as this Perl
> one at http://www.webbasedemail.com/. If
> I think that Rob nailed it in the posting right after yours. This is only
an issue where you have a trigger that inserts into a different table that
has an IDENTITY field in it. In that case, @@IDENTITY will return the
inserted ID from the trigger rather than your your original insert. Also,
a
Hi, I'm trying to index a collection but I'm getting the error:
Error E3-0036 (VDK): Cannot load style.ddd schema (document catalog) in
collection
:\cfusionmx\verity\collections\querySearchB8CA8333-E07D-D6CD-BD0AC50D3F301B9
4\custom
I've googled all around but I couldn't find anything...
Verity
Can scope_identity() be used to get identities in a query such as the
piece I have below? I tried using Select Scope_Identity() AS emailID but
my query kept complaining that emailID didn't exist.
SET NOCOUNT ON
DECLARE @thisID int
DECLARE @emailID int
BEGIN t
What kind of scenario would make me to use CFLOCK with these tags? :-D
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Nevermind, I got it.
Thanks,
Ben
-Original Message-
From: Ben Densmore
Sent: Thursday, March 11, 2004 3:53 PM
To: CF-Talk
Subject: RE: Reliable way to get ID of inserted record
Can scope_identity() be used to get identities in a query such as the
piece I have below? I tried using Selec
Ben,
In this situation you would want to use your @emailID variable to hold the value of Scope_Identity.
So something like the following should work...
SET @emailID = SCOPE_IDENTITY()
Instead of
Select Scope_Identity() AS emailID
HTH,
Jeff Garza
- Original Message -
From: Ben
I'm looking for a reasonably priced Tiff viewer for an intranet. The best
one that I've found so far, Tiffy, is from a German company and I don't
speak German, so we are not getting very far communication wise...TIA->
Tyler Silcox
[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscript
> From: Ben Densmore
>
> Can scope_identity() be used to get identities in a query
> such as the piece I have below? I tried using Select
> Scope_Identity() AS emailID but my query kept complaining
> that emailID didn't exist.
You're within a SET NOCOUNT ON, so it won't be output to the query
Any scenario where there is a possibility of two users trying to modify the same file/directory at the same time. Which in most internet applications is nearly all possible scenarios.
HTH.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code
I use tiff surfer. EXTREMELY happy with it. The pictures load up isntantly. other viewers i tried had a loading time. Tiff surfer doesnt. It's an IE/netscape plugin.
You can aso ask the folks at visionshape (the company) to customize the program for your needs.
We use tiff surver with a CF
Hello --
I have a need to automatically retrieve a document stored in a secure
remote site. Thus, I need to simulate a logon to the remote site (which
is driven by ASP.NET, but that shouldn't be relevant). This should be
easy as pie: do a cfhttp POST to simulate a logon, then do a cfhttp GET
to r
Ken,
Question on BlueDragon, my Windows XP dev box has both CF5.0 and CFMX6.1,
since I use different ports for web servers, a lot of times I have both versions running to match clients/users' environments. Now, if I'm going to download and install the BlueDragon's free edition, btw, I'm not going
How are you creating the index? Are you using the cold fusion cfindex tag, or are you using the vdkmk utility? (Or vspider or other indexer?)
I am asking this because this will tell me where to have you look for the verity style files.
If you are using cfmx and the cfindex tag, and are creating a
> Does anyone know of there are any things that have come up in MX
> that would disallow auto-filling PDF forms?
Not exactly sure what problem you're having but I've handled this
using CFMX 6.1 (and earlier) using CFCONTENT _and_
CFHEADER as follows:
TEMPLATE="myfdfname.fdf">
Your FDF file
I'm indexing using the cfindex tag...
There is a style.ddd in the default directory(cfusionmx\lib\common\style and
cfusionmx\lib\common\style\file) and all the commom files get copied to the
collections style folder when I create a new collection.
The style.ddd is the original and looks like this
No problem:)
> -Original Message-
> From: Jeff Beer [mailto:[EMAIL PROTECTED]
> Sent: 11 March 2004 17:31
> To: CF-Talk
> Subject: RE: Split screen editor for two files
>
>
> Man.. I completely forgot about Jedit. I've used it before.. Doh!
>
> Thanks Tom
>
> -Original Message
Can anyone give me any best practice scenarios to integration or synchronization of CF with an existing PeopleSoft implementation? Client is very touchy with us having access to live data. We will need to have read only privileges, capability of creating some sort of CSV or table for PeopleSoft t
I am setting up some script to monitor a mail box and suck newly arriving
emails into a database for a pro bono site I do. It will essentially be
retrieving email releases sent by email and display them in the site. The
problem I have is that since November last year the organisation in question
de
XEmacs...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Content = Rereplace(content, "]*>", "", "all");
Content = Rereplace(content, "]*>", "",
"all");
Content = Rereplace(content, "]*>", "", "all");
Content = Rereplace(content, "<[a-zA-Z][^>]*>", "", "all");
Content = replace(content,
I was taking a practice exam for the MX Certification and one of the questions sparked some confusion with a colleague.
Basically, here's the confusion:
This code: #(True AND 3)# displays "3"
This code: #(False AND 3)# displays "False"
Now, I can accept the fact that CF handles the first lin
Actually, I think what's happening is CF is returning the value of the last
evaluated portion of the _expression_. In the first, both need evaluation, so
we return 3, the second one. If the second, only the first needs evaluation
(becase we know the _expression_ can't be true if either part is fa
Kevin,
OK I understand now... Yeah actually I do have the billing information auto
insert on the credit card form. I just have it disable for testing right
now.
And yes we will have a much larger selection of unscented candles once the
site goes live. The current products you see will be rep
Original Message:
> From: "Barney Boisvert" <[EMAIL PROTECTED]>
> Actually, I think what's happening is CF is returning the value of the last
> evaluated portion of the _expression_. In the first, both need evaluation, so
> we return 3, the second one. If the second, only the first needs evaluati
Consider this stored procedure (part of package DLC):
PROCEDURE dlc_mail_countMsg (
studentID IN number,
mailInfo OUT types.cursorType
)
AS
BEGIN
OPEN mailInfo FOR
SELECT
count(*) AS msgCount
FROM
tblMail
WHERE
mIndividID = studentID AND
But it's not changing the values, it's only coercing them as much as it
needs for evaluation. Not like a function call that returns boolean. It
one of the little bits of weirdness that are present in loosely-typed
languages.
Cheers,
barneyb
> -Original Message-
> From: Scott Brady [mail
Matt I understand your point... And when I first had this site live last
year I actually had the ordering process like this, but I kept getting
emails from people wanting to know where they could see there order status.
So in order to do this I needed to have the customer login where the
customer c
I use the CF_MAXID function.
Dwayne Cole, MS in MIS, MBA
Certified Advanced ColdFusion Developer
850-591-0212
"It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all "sound
Neal did you see this:
-
From: Erika L Walker-Arnold [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:37 PM
To: CF-Talk
Subject: RE: Marketing / Design ???
BUT ... your continue shopping button is not really usable ... you use a
_javascript_ GoBack ... an
Bret-
Switch-box is a framework. The CF5 version of the files are on the
developer exchange. The all framework code works with CFMX6 and CFMX 6.1.
The framework development tool will not work with CF6 because it uses
CFTree. There the version on the exchange uses Access, but on request I can
Hi Neal,
What I've done for that in the past -- letting users query back for info -- is give them a link in their thank-you-for-paying-us email that then lets them view order history, status etc.
When they use that link *then* they go thru a username and password picking routine, which is only ne
Thanks Erika,
I did miss that...Thanks, though I new I needed to fix it. Its working as it
should now and will send the customer to the last item he or she added to
the cart.
Neal Bailey
www.BlissFulEssence.com
E-mail: [EMAIL PROTECTED]
_
From: Erika L Walker-Arnold [mailto:[EMAIL
Matt thanks for the ideas...
I am revisiting these ideas now that I am redesigning the backend to be more
user friendly for me and my wife as she is the one that's going to be
running this creation of mine.
Neal Bailey
_
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Hi Neal,
Wha
StripHTML UDF by Raymond Camden:
http://www.cflib.org/udf.cfm?ID=12
or
FormStripHTML by Douglas Williams:
http://www.cflib.org/udf.cfm?ID=434
Peter Tilbrook
Transitional Services - Enterprise eSolutions
Centrelink (http://www.centrelink.gov.au)
2 Faulding Street
Symonston ACT 2609
Tel: (02) 6
Hi everyone,
I've got a form with a selection box. That value is used to populate a SQL WHERE clause. As in:
SELECT *
FROM mailinglist
WHERE mail_group = '#form.group#'
Easy.
Now I need give the user the ability to have multiple selections in the on the form, so they can choose multiple groups
http://www.macromedia.com/software/jrun/
Next stop: JRun 4.1 and JRun 5!
Damon Cooper
Dir Engineering, ColdFusion & JRun
Macromedia
[EMAIL PROTECTED]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Hot off the press: the Updater for Dreamweaver MX 2004 is now available.
With the release of the Dreamweaver Updater, all Macromedia Studio MX 2004
products have been optimized for better quality and performance.
New Studio MX 2004 purchases will include all of the updated products.
Existing u
SELECT *
FROM mailinglist
WHERE mail_group in ( #thisgroup#,#thatgroup#,#anothergroup#)
Wrap single qoutes around each element if mail_group is varchar datatype.
Nick Han
>>> [EMAIL PROTECTED] 03/11/04 04:33PM >>>
Hi everyone,
I've got a form with a selection box. That value is used to populat
Thanks Nick,
I must be missing something, or don't understand.
My multi select box on page one looks like this"
Please Select
#mailgroupname#
So the form variable "group" gets passed as a list seperated by commas.
If a user selcts two items, I get "itemone, itemtwo" and the whole thing
I am storing a grunch of files of different types in a directory on my
server. For obscurity (don't ask it's a legal thing) I store them with names
like DOC_**.AAF Where the ** is an id number. I store the mime type and
orignal filename in a database table. My Flash application calls a
coldfusio
Use the list functions to break apart the group variable and loop through
each list item.
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:24 PM
To: CF-Talk
Subject: Re: Multiple Selections to populate a SQL or operator.
Thanks Nick,
I mu
isnt there a mathematical function called "AND" and you can and two
numbers to determine a bit value?
tony
r e v o l u t i o n w e b d e s i g n
[EMAIL PROTECTED]
www.revolutionwebdesign.com
its only looks good to those who can see bad as well
-anonymous
-Original Message-
From: Ba
Tony Weeg wrote:
> isnt there a mathematical function called "AND" and you can and two
> numbers to determine a bit value?
>
> tony
>
> r e v o l u t i o n w e b d e s i g n
> [EMAIL PROTECTED]
> www.revolutionwebdesign.com
>
> its only looks good to those who can see bad as well
> -anonymous
Is this same for CFMX 6.1 running on JRun? :-D
Stace
_
From: Damon Cooper [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:54 PM
To: CF-Talk
Subject: JRun 4 Updater 3 Now Available
http://www.macromedia.com/software/jrun/
Next stop: JRun 4.1 and JRun 5!
Damon Cooper
Dir Eng
>
Cant do that, i need to check if its taking more time than CFMX Server
setting,
if so execute some other logic to handle the situation correctly.
Joe Eugene
-Original Message-
From: John Uebel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 10, 2004 11:43 PM
To: CF-Talk
Subjec
or simply backing up
hey & its FREEE
http://mm-exporter.joexx.de/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
The DW updater is really worth, the team fixed literally many hundreds of
bugs.
I felt DW 2004 was pushed out of the door too early, but the update send a
strong message to the userbase about how much the DW's team is committed to
deliver a quality product
Of course, if you don't like DW before,
101 - 183 of 183 matches
Mail list logo