RE: Pivot table confusion
Richard,
A simple way to do this is to use a "Tally" table. A "Tally" table
contains one column, ID, that contains numbers from 1 to [x]. You can
then do joins against this table to do what you are looking for. Here's
an example:
SELECT t.ID,
a.Taken,
a.assessment_ID
FROMTally as t
LEFT OUTER JOIN assessment a on
YEAR(a.Taken) = YEAR(DATEADD(YEAR,-(t.ID -
1),now()))
WHERE t.ID <= 3
AND youth_id = 'X'
That will output NULLs for years that don't exist. Let me know if you
have any questions.
Regards,
Chris
-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 8:13 PM
To: CF-Talk
Subject: Re: Pivot table confusion
OK maybe I need to take a step back and give you some more detail.
Or maybe I'm just not going to comprehend what you guys are telling me.
I have a single table called assessment with these fields.
[assessment_id] [int] IDENTITY(1,1) NOT NULL
[youth_id] [varchar](26) NOT NULL
[org_id] [varchar](26) NOT NULL
[Taken] [datetime] NOT NULL
[assessment_type] [int] NOT NULL
Ive tried any number of answers from googling, and Ive been on this all
day
and I simply don't follow what your doing. But this is what I'm after.
I'm only going to display 3 years so
#Year(dateadd("",-2,now()))# Through #year(now())#
but the part i get lost at is creating the empty cells for the values
that
Don't exist.
---2005--2006--2007--Total
--
assessment_type 1-0-510-15
assessment_type 2-3-011-14
assessment_type 3-5-5-9-19
--
Grand Totals--81030-48
I really appreciate all the help but you would think their was an easy
way
to do this with SQL. Seems it would be something you would need rather
often. What I keep coming up with is the following table with the type
repeated if theirs more than one year.
---2005--2006--2007--Total
--
assessment_type 1---510-15
assessment_type 2-3--11-14
assessment_type 3-5--5
assessment_type 3---55
assessment_type 3-9--9
--
Grand Totals--81030-48
Totally Confused
~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288714
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Table Data
This can be accomplished by using a Tally table. A "tally table" is simply a table that contains one column, ID, that increments up to several thousand (or several million, depending on your application). For this application, you would use it like this: Tally -- ID int MyData -- Amount int Datedatetime SELECT t.ID, m.Amount, m.date FROMTally as t LEFT OUTER JOIN MyData m on Hour(m.date) = t.ID WHERE t.id <= 24 HTH, Chris > -Original Message- > From: Robert Rawlins - Think Blue > [mailto:[EMAIL PROTECTED] > Sent: Friday, May 04, 2007 2:33 AM > To: CF-Talk > Subject: Table Data > > Morning Guys, > > > > I'm a little stumped on how to resolve this problem, hopefully someone > will > have a bright idea on how to achieve it. I have a bunch of table data > which > gets displayed hour on hour for a certain time period. This works > absolutely > perfectly at the moment, however the little annoyance occurs when the user > is looking at today's information. If they look at any past dates then > they > get a nice full length table with 24 rows (one for each hour) but if they > look at today's date then it'll only display the records that have been > published into persistence up until that moment, so if they check it first > thing in the morning they only get 6 or 7 rows of data. > > > > This isn't really a big deal, but it looks a little untidy for > presentation > purposes, and what I'd like to do if have a full set of 24 rows there, but > only populate the ones that have information, then if for some reason the > system went down for a couple of hours on a particular date it wouldn't > end > up with a funny 22 row table, it would just say 'no data' in the rows that > it didn't have data for. > > > > Does that make sense? What's the best way to achieve this? I'm thinking > perhaps a cfloop from 1 to 24 or something like that. > > > > Thanks for any ideas, > > > > Rob > > > > ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Withholding Calculator
I'm hoping someone here can point me in the right direction. I am looking for a W4 withholdings calculator that is CF compatible (COM, Java, SOAP, whatever). Is there anything out there like that? Thanks, Chris ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231498 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Dynamic cfc function call
That sounds like it would work. Thanks! Chris >>> [EMAIL PROTECTED] 08/23/05 01:18PM >>> Yes, you're exactly right. When you pull a method out of a CFC, it's no longer part of the CFC. In your setter, you're setting variables.XXX, which outside a CFC, is part of the page's variables scope. When you call the extracted getter, it uses the page's variable scope as well, so it works as well. Since the CFC doesn't use the page's variable scope, the in-CFC methods aren't refering to the same variable, and consequently don't work as expected. If you want to call a method dynamically, take a look at CFINVOKE. You still invoke the method on the CFC instance, but you can pass in a dynamically computed method name. Would that meet your need? cheers, barneyb On 8/23/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote: > I am attempting to dynamically call a cfc's functions without resorting to > evaluate, but something isn't working correctly. > I have read in the archive that you can assign a function to a var, then call > the var as a method but this doesn't appear to be working with setters in a > cfc. Take the following code for example: > > tempSetter = myComponent["setID"]; > tempSetter(1); > > Although the function appears to complete without error, the value isn't > retained in the myComponent cfc. It almost appears as if the dynamic > function is executing in an entirely different scope. > > If I create another dynamic function call to retrieve the data, it appears to > be there, but if I call the function directly, the data isn't there: > > tempGetter = myComponent["getID"]; > writeoutput(tempGetter()); // displays "1" > writeoutput(myComponent.getID()); //displays nothing > > Is there something I'm missing? > > TIA, > Chris > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216085 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Dynamic cfc function call
I am attempting to dynamically call a cfc's functions without resorting to evaluate, but something isn't working correctly. I have read in the archive that you can assign a function to a var, then call the var as a method but this doesn't appear to be working with setters in a cfc. Take the following code for example: tempSetter = myComponent["setID"]; tempSetter(1); Although the function appears to complete without error, the value isn't retained in the myComponent cfc. It almost appears as if the dynamic function is executing in an entirely different scope. If I create another dynamic function call to retrieve the data, it appears to be there, but if I call the function directly, the data isn't there: tempGetter = myComponent["getID"]; writeoutput(tempGetter()); // displays "1" writeoutput(myComponent.getID()); //displays nothing Is there something I'm missing? TIA, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216078 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query Problem - Brain Cloud
This looks like a good use of a Tally table. A "Tally" table is a table that contains just an ID field with records from 1 to 10,000 (you can use any upper bound you need). You can then join this table to generate queries based on ranges. To test, I created the following table: ID int arrivalDate smalldatetime numDays int Then populated the table with this data: ID arrivalDate numDays --- 1 7/28/2005 2 2 7/20/2005 4 3 7/26/2005 1 Finally, I used the following query to determine the available dates: declare @startDate smalldatetime,@endDate smalldatetime select @startDate = '7/15/2005', @endDate = '7/30/2005' SELECT d.ID, dateAdd(day,(t.id -1),@startDate) as tallyDate, (CASE WHEN d.ID IS NULL THEN 1 ELSE 0 END) as isAvailable, d.arrivalDate, dateAdd(day,d.numDays,d.arrivalDate) as depDate, d.numDays FROMTally as t left outer join testDateRange as d on (dateAdd(day,(t.id-1),@startDate) >= d.arrivalDate and dateAdd(day,(t.id-1),@startDate) < dateAdd(day,numDays,arrivalDate)) WHERE t.ID <= dateDiff(day,@startDate,@endDate) ORDER BY tallyDate Which returned the following: ID tallyDate isAvailable arrivalDate depDatenumDays --- -- --- --- -- --- NULL07/15/05 1 NULLNULL NULL NULL07/16/05 1 NULLNULL NULL NULL07/17/05 1 NULLNULL NULL NULL07/18/05 1 NULLNULL NULL NULL07/19/05 1 NULLNULL NULL 2 07/20/05 0 07/20/0507/24/05 4 2 07/21/05 0 07/20/0507/24/05 4 2 07/22/05 0 07/20/0507/24/05 4 2 07/23/05 0 07/20/0507/24/05 4 NULL07/24/05 1 NULLNULL NULL NULL07/25/05 1 NULLNULL NULL 3 07/26/05 0 07/26/0507/27/05 1 NULL07/27/05 1 NULLNULL NULL 1 07/28/05 0 07/28/0507/30/05 2 1 07/29/05 0 07/28/0507/30/05 2 Any row with a NULL id is an available date. The isAvailable col takes this into account and gives a 1 for available and 0 for not. HTH, Chris >>> [EMAIL PROTECTED] 07/28/05 02:27PM >>> here's a timeline in days (if you don't have fixed-width font, C&P into something that does): 123456789 xxx reservation 1 xxx reservation 2 x reservation 3 q desired range there are two possible days available: 4 and 6. That's the problem he's trying to solve. cheers, barneyb On 7/28/05, Jennifer Larkin <[EMAIL PROTECTED]> wrote: > Something like this wouldn't handle them > where arrivaldate >= #arrivaldate# and departuredate <= #departuredate# > > ? > > Maybe I don't understand what you are trying to do? > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: find_string in db
Ahh, you're using Oracle. Yea, it's going to choke on that one. You could always try porting it. :) >>> [EMAIL PROTECTED] 07/06/05 12:37AM >>> That's unlikely to work in Oracle ;-) On 7/6/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote: > Daniel, > > Included below is a stored procedure that you can use to search any or all > columns in all tables. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: find_string in db
Daniel,
Included below is a stored procedure that you can use to search any or all
columns in all tables.
Once you have installed the SP, call it as follows:
exec spDBSearch @value='MySearchString'
You can also specify a specific column, table or datatype. Let me know if you
have any questions.
ALTER PROCEDURE sp_DBSearch (@value varchar(255),@col varchar(255) = '',@table
varchar(1024) = '', @datatype varchar(20) = '', @debug int = 0)
as
SET NOCOUNT ON
-- cursor vars
DECLARE @colName varchar(255),@tableName varchar(255),@dType varchar(50),@op
varchar(10),
@searchVal varchar(255),@query varchar(1024),@Where
varchar(1024),@From varchar(255),
@recordCount int
SELECT @op = '=',
@recordCount = 0
CREATE TABLE #x (RecordCount int)
DECLARE cur CURSOR FAST_FORWARD
FOR
SELECT c.name as colName
--,c.id
,o.name as tableName
--,o.type
,t.name as "DataType"
FROMsysColumns as c
left outer join sysObjects as o on (o.id = c.id)
left outer join sysTypes as t on c.xtype = t.xtype
WHERE (
c.Name like IsNull(nullIf(@Col,''),c.name)
)
and
o.name like IsNull(nullIf(@table,''),o.name)
AND
t.name like IsNull(nullIf(@datatype,''),t.name)
AND
o.type = 'u'
order by o.name,c.Name
OPEN cur
WHILE (1=1)
BEGIN
FETCH NEXT FROM cur INTO @colName,@tableName,@dType
IF (@@FETCH_STATUS <> 0)
BREAK
SET @searchVal = @value
if (CHARINDEX('%',@value) > 0)
SELECT @op = 'LIKE',
@searchVal = + @value +
ELSE IF (CHARINDEX(',',@value) > 0)
SELECT @op = 'IN',
@searchval = '(' + @value + ')'
ELSE
SELECT @op = '=',
@searchVal = + @value +
SELECT @From = ' FROM ' + @tableName,
@Where = ' WHERE ' + @colName + ' ' + @op + ' ' +
@searchval
SELECT @query = 'SELECT count(*) as RecordCount' + @from + @where
INSERT INTO #x
exec (@query)
SELECT @recordCount = (SELECT top 1 recordCount FROM #x)
truncate table #x
if (@debug > 0)
print('Searching ' + @tableName + '.' + @colName + ' for ' +
@value + ' returned ' + cast(@recordCount as varchar(10)) + ' records')
if (@recordCount > 0)
BEGIN
SELECT @query = 'SELECT ''' + @tableName + ''' as
searchTable,''' + @colName + ''' as searchCol,*' + @from + @where
--SELECT@query = 'SELECT ''' + @tableName + ''' as
searchTable,''' + @colName + ''' as searchCol,* FROM ' + @tableName + ' WHERE '
+ @colName + ' ' + @op + ' ' + @searchval
exec (@query)
END
END
CLOSE cur
DEALLOCATE cur
DROP TABLE #x
>>> [EMAIL PROTECTED] 07/05/05 09:25AM >>>
I have a table that has about 50 columns. I want to be able to
search ALL columns for the string "***".
I can loop through the columnList with a set of LIKE commands, but is
there a way to search all columns without making 50 LIKE commands?
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211187
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Java jar/class locations without restart
Thanks for the info Mark. >>> [EMAIL PROTECTED] 06/13/05 07:43AM >>> I don't think you'll find a way for jars to be picked up automatically... I'm not aware of a way to do that in "regular" java (JVM settings, etc), so unless they have special class loader stuff explicitly for jars, or unless you find some code to do it yourself, I think you're out of luck. Basically, if you drop a class file in a classpath directory then it will be found (but not reloaded when it changes), but only jars explicitly mentioned in the classpath will be ever be searched; jars not mentioned are ignored. Again, you can probably do a custom classloader to get around this, but I've never used one. Mark -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 8:29 AM To: CF-Talk Subject: Java jar/class locations without restart I am reposting this question. I should have known better than to post on a Friday. ;) I am trying to determine where I can store Java jar files that will allow CF to find them WITHOUT reloading the server. Is this possible? Placing the jars in the WEB-INF/lib directory doesn't work without a restart, BUT.. adding classes to the WEB-INF/classes directory does. Why is it that CF can load classes without a restart but not jars? Is there something I'm missing here? Is there another location to place the jars so CF can find them without a restart? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209379 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Java jar/class locations without restart
I am reposting this question. I should have known better than to post on a Friday. ;) I am trying to determine where I can store Java jar files that will allow CF to find them WITHOUT reloading the server. Is this possible? Placing the jars in the WEB-INF/lib directory doesn't work without a restart, BUT.. adding classes to the WEB-INF/classes directory does. Why is it that CF can load classes without a restart but not jars? Is there something I'm missing here? Is there another location to place the jars so CF can find them without a restart? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Java class/jar locations
What's really strange is it appears that .class files can be "hot deployed", but not .jar's. Any clue why that would be? Chris >>> [EMAIL PROTECTED] 06/10/05 07:38AM >>> IIRC, the only stuff that gets reloaded live, Hot Deploy or something like that, are wars, ears, and servlets. DK On 6/10/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote: > > I have read through all of the documentation as well as Christian > Cantrell's blog regarding where to put Java classes and jars so that CF can > find them. But no matter where I try and put this problematic set of jars, > CF just won't see them. Is there a location that I can place the jars that > would allow CF to pick them up WITHOUT restarting the server? On my dev box, > I can manipulate the paths and restart, but on the production box I can't. I > need a way to upload and make changes to classes and jars without restarting > CF. Is this possible? > > Thanks, > Chris > > > This email and its attachments may contain confidential information > which is intended only for the use of the person(s) named above. > If you are not the intended recipient, you are hereby advised that > any disclosure, copying, distribution or the taking of any action > based on the contents of this information is prohibited. If you > have received this transmission in error, please notify the sender > and delete this email from your computer. Thank you. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209200 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Java class/jar locations
I have read through all of the documentation as well as Christian Cantrell's blog regarding where to put Java classes and jars so that CF can find them. But no matter where I try and put this problematic set of jars, CF just won't see them. Is there a location that I can place the jars that would allow CF to pick them up WITHOUT restarting the server? On my dev box, I can manipulate the paths and restart, but on the production box I can't. I need a way to upload and make changes to classes and jars without restarting CF. Is this possible? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209190 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Java Interfaces
Actually that's exactly what I'm using. I had it lying around for CFEclipse, but it just never stuck (Homesite/CFStudio kept calling be back). But for Java, it's great. Not really a raving review considering I haven't tried any other Java IDE's. At this point it does everything I need it to so it's perfect for me. Thanks, Chris >>> [EMAIL PROTECTED] 06/09/05 11:40AM >>> While we're on the topic.. If you find yourself doing Java, the Eclipse IDE is a great platform for it. And there's the CFEclipse plugin that includes CF editors and various other things, so you can do your CF work in the same application. And it itegrates easily with myriad version control systems too. Very nice package. cheers, barneyb On 6/9/05, Chris Terrebonne <[EMAIL PROTECTED]> wrote: > Thanks Nathan and Barney for clearing this up for me. > > I guess this was as perfect excuse as any to finally learn Java. Man! I was > surprised how simple it was. I know C++ and I heard that the transition to > Java was easy, but I had no idea just how easy it was. I should have done > this along time ago. I know this is starting to drift into OT-land but... > it's nice to just code away without worrying about memory management. If I > never malloc again... it will be too soon ;). > > Thanks for the inadvertent "push", guys. > > Chris -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209141 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF and Java Interfaces
Thanks Nathan and Barney for clearing this up for me. I guess this was as perfect excuse as any to finally learn Java. Man! I was surprised how simple it was. I know C++ and I heard that the transition to Java was easy, but I had no idea just how easy it was. I should have done this along time ago. I know this is starting to drift into OT-land but... it's nice to just code away without worrying about memory management. If I never malloc again... it will be too soon ;). Thanks for the inadvertent "push", guys. Chris >>> [EMAIL PROTECTED] 06/08/05 01:26PM >>> Perhaps there's already a java object that impliments this interface? Look around to see if there's anything that impliments your target class. Otherwise, you could make one in java and createObject() it in CF. -nathan strutz Chris Terrebonne wrote: > I am trying to use CF to access a Java class method. One of the required > arguments is an object extended from an interface. Using createObject() to > instantiate the object, then passing it to the method as an argument causes > an error because the interface is abstract and must be extended. Since > cfcomponent won't allow me to extend a Java interface, how can I use this > interface? Any suggestions? > > Thanks, > Chris > > > This email and its attachments may contain confidential information > which is intended only for the use of the person(s) named above. > If you are not the intended recipient, you are hereby advised that > any disclosure, copying, distribution or the taking of any action > based on the contents of this information is prohibited. If you > have received this transmission in error, please notify the sender > and delete this email from your computer. Thank you. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CF and Java Interfaces
I am trying to use CF to access a Java class method. One of the required arguments is an object extended from an interface. Using createObject() to instantiate the object, then passing it to the method as an argument causes an error because the interface is abstract and must be extended. Since cfcomponent won't allow me to extend a Java interface, how can I use this interface? Any suggestions? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209010 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: FTPS? (was RE: SFTP?)
Thanks for the help everyone. I'll start digging through those libs and see what I can use. Thanks again, Chris >>> [EMAIL PROTECTED] 06/08/05 10:06AM >>> > Actually, I had my acronym backwards (which apparently makes > a HUGE difference :). > I am really looking for FTPS ability (FTP over SSL). > Sorry for the confusion. Any idea where I can find a CF > resource for that protocol? The library I pointed you to does FTPS as well as SFTP. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
FTPS? (was RE: SFTP?)
Actually, I had my acronym backwards (which apparently makes a HUGE difference :). I am really looking for FTPS ability (FTP over SSL). Sorry for the confusion. Any idea where I can find a CF resource for that protocol? Thanks again, Chris >>> [EMAIL PROTECTED] 06/08/05 08:58AM >>> > Can CF do secure FTP (SFTP)? No. > If not, is there a Java class that can be used in CF that will? You could try this: http://www.jscape.com/sftp/ I haven't tried it myself, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208950 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SFTP?
Can CF do secure FTP (SFTP)? If not, is there a Java class that can be used in CF that will? Any advise? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208938 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ACH file format
Any chance one of you have experience with using CF to format a standardized ACH file? Any CFC's or custom tags that will do this? I was going to write one, but no need to reinvent if it already exists. Thanks! Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Permission Models
Morning everyone. I have developed a permission model for an application but, before I start coding around it, I wanted to see how everyone else handles this problem. In this application, a "Party" is any entity that can act as an individual (Person,Group, Organization,Department, etc). An "Object" is an application resource used or accessed by a "Party" (Manage Users, Manage Contacts, Run Reports, etc.). A "Party" can have permission based relationships with both "Objects" and other "Parties". "Objects" can also have permissions on other "Objects". To handle this, I created the an Entity_ACL table: Parent_IDint (FK to either Party_ID or Object_ID) Child_ID int (FK to either Party_ID or Object_ID) Parent_Type tinyint (0 = Party, 1 = Object) Child_Type tinyint (0 = Party, 1 = Object) Permission int (bitmask [read,write, delete, etc]) When a Party requires access to an Object or Party, the access is verified by either direct permissions (i.e. entry in the above table) or inherited (Some parent along chain has permission). Is there something I'm missing? How does everyone else handle this situation? Any advice, ideas, criticisms or demoralizing comments to share? TIA, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Database Normalization Question
In a relationship model like this, you can track history by assigning a time span for the relationship. For example, you would modify your Employee_Positions table to contain from and to date fields: Employee_Positions Employee_ID Position_ID fromDate toDate You could then find the current position like this: SELECT Employee_ID, Position_ID FROM Employee_Positions WHERE getDate() BETWEEN fromDate AND isNull(toDate,getDate()) HTH, Chris > -Original Message- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 14, 2005 3:49 PM > To: CF-Talk > Subject: RE: Database Normalization Question > > > What happens you you have the same employee, but has been moved to a new > position and you still need to keep the history? > > For example, last year I was a grunt. This year, I am a slave. How > would you track that? > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 14, 2005 1:09 PM > To: CF-Talk > Subject: Database Normalization Question > > Greetings, all... > > Instead of two tables like this: > > Positions (Yes, I like plural table names :o) > >Position_ID (Primary Key) >Position_Title >Position_Description >etc > > Employees > >Employee_ID (Primary Key) >Position_ID (Relational Key) >Employee_FirstName >Employee_LastName >etc > > > > I've seen many use examples of three tables, a third table which seems > to be the way of creating relationships between tables. > I just typically do it with two tables and what I always thought of as a > "Foreign Key", which may not be the accurate term anyway. Here's a > probably poor example of the three table scheme I've seen: > > Positions > >Position_ID (Primary Key) >Position_Title >Position_Description >etc > > Employees > >Employee_ID (Primary Key) >Employee_FirstName >Employee_LastName >etc > > Employee_Positions > >Employee_ID >Position_ID > > > It seems like the third table is used to tie the Positions table and > Employees table together, but I don't see the benefit of creating that > third table when I can just put the Position_ID in the Employees > Table... > > This may be a poor example of what I'm talking about. I can't think of > an exact example I've seen, but those of you who do this will know, > probably, what I've referring to. I thought I've been doing correct > normalization. > Using the third table seems to cause the use of repeated data and more > tables than the first example...so why is it done? What am I missing in > my database design, which, of course, would determine how I have to code > in CF and SQL... > > Rick > > > > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic cfoutput groups
I'll take a look at that article. Thanks. As for the query, there isn't just one. This is more of a dynamic reporting application where queries are entered, fields defined and a nice shiny report is spit out. The performance of the query is independent of the application (at least for my current goal). I was hoping that by using the cfoutput grouping, I would gain a small performance boost over manual grouping. This is unlikely, but I figured I'd give it a shot anyway. Thanks again, Chris >>> [EMAIL PROTECTED] 04/14/05 10:35AM >>> You can use CF with OLAP. Read http://sys-con.com/story/?storyid=46790 for a decent jumping-off point. But if you don't want to pursue OLAP (it's not exactly painless) there are several very capable members of this list who have helped me in the past with my ugly web-based reporting queries. If you post the query you may get some very useful tips on how to solve the performance problems at the root... -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 8:35 AM To: CF-Talk Subject: RE: Dynamic cfoutput groups Thanks for the response. For the application requirements, this should remain a web-based CF reporting app. I would just like to use cfoutput to the do the display grouping rather than handling it manually. Any thoughts? Thanks, Chris >>> [EMAIL PROTECTED] 04/14/05 09:23AM >>> It sounds like you're after a kind of pivot table functionality... Do you have OLAP capabilities at your disposal? (MS Reporting Services is installed w/ SQL Server if that applies...) -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 6:21 AM To: CF-Talk Subject: Dynamic cfoutput groups Morning everyone. I currently have a reporting app that allows output to be grouped dynamically based on user preference. The user can select an unlimited number of values to group on and the groups are nested accordingly. I wasn't able to figure out a way to performing the grouping using cfoutput's group attribute, so I just manually break out and track the groups. Now that this app is in production, I am finding a performance hit on very large record sets and I am again exploring cfoutput's grouping as an option. Does anyone have any experience using cfoutput to dynamically construct nested groups? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic cfoutput groups
Thanks for the response. For the application requirements, this should remain a web-based CF reporting app. I would just like to use cfoutput to the do the display grouping rather than handling it manually. Any thoughts? Thanks, Chris >>> [EMAIL PROTECTED] 04/14/05 09:23AM >>> It sounds like you're after a kind of pivot table functionality... Do you have OLAP capabilities at your disposal? (MS Reporting Services is installed w/ SQL Server if that applies...) -Original Message- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 6:21 AM To: CF-Talk Subject: Dynamic cfoutput groups Morning everyone. I currently have a reporting app that allows output to be grouped dynamically based on user preference. The user can select an unlimited number of values to group on and the groups are nested accordingly. I wasn't able to figure out a way to performing the grouping using cfoutput's group attribute, so I just manually break out and track the groups. Now that this app is in production, I am finding a performance hit on very large record sets and I am again exploring cfoutput's grouping as an option. Does anyone have any experience using cfoutput to dynamically construct nested groups? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202780 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Dynamic cfoutput groups
Morning everyone. I currently have a reporting app that allows output to be grouped dynamically based on user preference. The user can select an unlimited number of values to group on and the groups are nested accordingly. I wasn't able to figure out a way to performing the grouping using cfoutput's group attribute, so I just manually break out and track the groups. Now that this app is in production, I am finding a performance hit on very large record sets and I am again exploring cfoutput's grouping as an option. Does anyone have any experience using cfoutput to dynamically construct nested groups? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202758 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database Model Suggestions - Elections
Here are a few general db standards: http://livedocs.macromedia.com/wtg/public/coding_standards/database.html >>> [EMAIL PROTECTED] 03/29/05 01:37PM >>> Why is everyone naming their tables singularly? :) Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Database Model Suggestions - Elections
Off the cuff, I would do something like this: Candidate --- id (int) name (varchar) parent_ID (int) dependsOnParent (bit) parent_ID would signify which Prez the VP is affiliated with. dependsOnParent would signify if the child (VP) can run alone or not. The query would be something like this: SELECT p.ID, p.name, c.ID as Child_ID, c.Name, c.Parent_ID, c.dependsOnParent FROM Candidate p LEFT OUTER JOIN Candidate c on (c.parent_ID = p.ID) WHEREp.Parent_ID = 0 OR (p.Parent_ID = 1 AND c.dependsOnParent = 0) Something like that should work. HTH, Chris >>> [EMAIL PROTECTED] 03/29/05 10:38AM >>> I would like to get some opinions on how best to structure a simple election database for my intranet site. Most of the time, an election will have different offices, or positions, for which candidates run. In these instances, there is one candidate running for a position. Every now and then, we have running partners like President and Vice-President. In our elections, if you vote for a president or vice-president, you get the running-mate as well. So, to summarize: Election Situation 1 (Everyone for himself): Pres Candidates: Bill Fold v. Jim Nasium Vice-Pres Candidates: Seymour Butts v. Harry Pitts Election Situation 2 (Pre-defined running mates): Pres/Vice-Pres Candidates: Bill Fold/Seymour Butts v. Jim Nasium/Harry Pitts I could just make "Bill Fold/Seymour Butts" the single candidate name, but that doesn't lend itself to storing information about each running mate. I could store each candidate separately and then somehow group them together as a single unit. Any suggestions? M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Spam:Message Board
Perfect! thanks >>> [EMAIL PROTECTED] 03/22/05 12:14PM >>> http://www.adersoftware.com/index.cfm?page=cfbb ____ From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Tue 3/22/2005 1:06 PM To: CF-Talk Subject: Spam:Message Board Does anyone know where I can download "Simple Message Board"? The url on the exchange no longer offers the download. If not, can anyone suggest a good message board app? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Message Board
Does anyone know where I can download "Simple Message Board"? The url on the exchange no longer offers the download. If not, can anyone suggest a good message board app? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Case Question?
The problem is that there are no values for those dates so there are no rows being returned. In this case isNull won't work. An easy way to do this is if you query against a table containing the dates then join the orders table. If you are using SQLServer, you can do the following: DECLARE @i int,@x int,@startDate smalldatetime, @endDate smalldatetime, @tempDate smalldatetime SELECT @startDate = '#varStartDate#', @endDate = '#varEndDate#', @x = 0; SET @i = DateDiff(DAY,@startDate,@endDate) CREATE TABLE #dates (day smalldatetime) WHILE (@x < @i) BEGIN SET @x = @x + 1 SET @tempDate = DateAdd(DAY,@x,@startDate) INSERT INTO #dates (day) VALUES (@tempDate) END SELECT Datepart(dw,d.Day), isNull(Count(o.OrderDate),0) AS TotalOrdersPerDay FROM#dates as d LEFT OUTER JOIN Orders as o on CONVERT(varchar,o.orderdate,1) = CONVERT(varchar,d.Day,1) WHERE o.Status = 'SHIPPED' GROUP BY Datepart(dw,d.Day) ORDER BY Datepart(dw,d.Day) ASC DROP TABLE #dates Hope that helps, Chris >>> [EMAIL PROTECTED] 03/07/05 07:47AM >>> tried isNull(), then did a dump of the query. i got results for sunday and monday...yet nothing (not even any zeroes) for the rest of the week. any other ideas? -Original Message- From: Ali Awan [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 5:32 PM To: CF-Talk Subject: RE: SQL Case Question? There is a function in SQL called IsNull which replaces a NULL result with whatever value you specify. Try doing this in the first line of your statement: SELECT IsNull(Count(OrderDate),0) AS TotalOrdersPerDay That way if the result set is NULL it will output a 0. Ali -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 2:23 PM To: CF-Talk Subject: OT: SQL Case Question? I'm trying to output total orders by day of the week. SELECT Count(OrderDate) AS TotalOrdersPerDay FROMOrders WHERE Status = 'SHIPPED' AND (OrderDate BETWEEN '#VarStartDate# 00:00:01' AND '#VarEndDate# 23:59:59') GROUP BY Datepart(dw,OrderDate) ORDER BY Datepart(dw,OrderDate) ASC This code works great, for the most part. How would I change this code so that if there were NO orders for a particular day, the query would return a result of zero [0] and not null or whatever it returns when there is no result? Does this make sense? I just don't want to have cells with nothing in them. Thanks, Che ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Correct Way To Query For Birthdays
SELECT * FROM myTable WHERE DAY(DOB) = DAY(GetDate()) AND MONTH(DOB) = MONTH(GetDate()) HTH, Chris >>> [EMAIL PROTECTED] 02/01/05 08:19AM >>> My field name is DOB, and I want to query the list for dates that match today. Of course, the year will never match. I have tried a bunch of different ways, but I know there must be a more elegant way! BTW: CFMX and Access TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduling/Appointment application
Happy Holidays everyone! A few months ago there was a pretty in depth discussion regarding the database model and programming techniques of a scheduling/appointment application, but I can't seem to find it in the archives anywhere. If anyone could point me to this discussion or to any articles related to this, I would appreciate it. Right now, I am looking at mimicking the SQL sysjobschedules methodology. The only drawback is their use of bitmasks for frequency intervals could make for an unnecessarily complex calendar query. I'm sure someone has come across a better method. If anyone has any advise or resources to share, I'm all ears. Thanks in advance, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ASP book for CF programmer?
Thanks Adam. I appreciate the info. I have looked into your crash course and it looks great. Unfortunatly I wouldn't have company support so that puts the crash course a little out of my range. I think I'll have to stick to the book route. I have noticed the drastic range of book available. They are either for the absolute beginner or intermediate ASP developer. Nothing for the experienced programmer wishing to learn ASP. I'll let you know if I find anything useful. Thanks again, Chris >> I am currently a long time CF and C++ programmer and I want to try my hand >at ASP.NET (VB & C#). Any other CF'ers made the ASP transition? If so, >were there any books that you found that were good for experienced >programmers trying to pick up ASP.NET? Any advise or resources to share? > >Chris, > >I haven't seen any truly good books for making the transition. Either they >are too simplistic and would insult your experience as a CF developer, or >they concentrate mostly on the C# language rather than its use in >implementing an ASP.NET app. The main Microsoft Press book on the subject >is full of errors and important files are missing. In fact, it looks like >they were trying to write two books at one time --one for C# and one for >VB.NET -- and forgot to change some of the references to VB.NET in the C# >book. > >If you're looking for a good book on the C# language itself then Mastering >Visual C#.NET from Sybex is good. > > > You should join us for our intensive 5-day training course "C# & ASP.NET >for ColdFusion Developers" that *exactly* fits your need. Details are on >http://www.ColdFusionTraining.com. > > >Respectfully, > >Adam Phillip Churvis >Member of Team Macromedia > >Advanced Intensive Training: >* C# & ASP.NET for ColdFusion Developers >* ColdFusion MX Master Class >* Advanced Development with CFMX and SQL Server 2000 >http://www.ColdFusionTraining.com > >Download CommerceBlocks V2.1 and LoRCAT from >http://www.ProductivityEnhancement.com > >The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ASP book for CF programmer?
Yea, it's my company all right. Just not the reasons they would hope for. ;) Chris > This may or may not be applicable in your situation, but if it's your > company that is nudging you into ASP.NET, try and talk them into > sending you to a 5 day MS course on the language. I just took one in > C# and it was great. (they aren't cheap though) > > Brian > - Original Message - > From: Chris Terrebonne > To: CF-Talk > Sent: Wednesday, August 11, 2004 2:35 PM > Subject: SOT: ASP book for CF programmer? > > > Hello, > > I hope this isn't too off topic, but I figured this would be the best > place to get good info. > > I am currently a long time CF and C++ programmer and I want to try my > hand at ASP.NET (VB & C#). Any other CF'ers made the ASP transition? > If so, were there any books that you found that were good for > experienced programmers trying to pick up ASP.NET? Any advise or > resources to share? > > Thanks for any info you could provide. > > Regards, > Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: ASP book for CF programmer?
Hello, I hope this isn't too off topic, but I figured this would be the best place to get good info. I am currently a long time CF and C++ programmer and I want to try my hand at ASP.NET (VB & C#). Any other CF'ers made the ASP transition? If so, were there any books that you found that were good for experienced programmers trying to pick up ASP.NET? Any advise or resources to share? Thanks for any info you could provide. Regards, Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Softball/Baseball db app? (Maybe OT)
Hmmm... I guess the whole mess. Calendar, win/loss, basic game stats, roster, etc. If I can find/create a simple interface, then some of the other parents/volunteers can enter the stats info. Since I'm just throwing the idea around, I don't have a clue as to what would be too much info. Dunno. Thoughts? Thanks, Chris >How much team information - the whole statsball mess or. .. > >Just about any CMS could display team information wins/losses next practice. > >I'm certainly interested in what you find out and I might be interested in >helping you write something for our firm intranet for our firm team. > >-Nate > > >-----Original Message- >From: Chris Terrebonne [mailto:[EMAIL PROTECTED] >Sent: Tuesday, April 20, 2004 10:29 AM >To: CF-Talk >Subject: Softball/Baseball db app? (Maybe OT) > > >Morning Everyone, > >I was thinking of putting together a db app that tracks the team information >and game schedule/results for my daughter's softball team. Before I started >hacking this out, I wanted to see if there was anything pre-rolled for this >purpose. Anyone done this before? > >Thanks in advance, and my apologies if this is OT. > >Chris > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Softball/Baseball db app? (Maybe OT)
Morning Everyone, I was thinking of putting together a db app that tracks the team information and game schedule/results for my daughter's softball team. Before I started hacking this out, I wanted to see if there was anything pre-rolled for this purpose. Anyone done this before? Thanks in advance, and my apologies if this is OT. Chris [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Encrypting Numeric ID's
Use this instead. It's fast and free. http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm Chris -- Original Message From: "Jason Dowdell"<[EMAIL PROTECTED]> Subject: RE: Encrypting Numeric ID's Date: Thu, 18 Apr 2002 18:38:53 -0400 >I tried all of those solutions except the htmleditformat. >Will the htmleditformat remove double quotes? > >~jason > >-Original Message- >From: Matt Robertson [mailto:[EMAIL PROTECTED]] >Sent: Thursday, April 18, 2002 6:07 PM >To: CF-Talk >Subject: Re: Encrypting Numeric ID's > > >How about this: > > > >--- >Matt Robertson[EMAIL PROTECTED] >MSB Designs, Inc., www.mysecretbase.com >--- > > >-- Original Message -- >from: "Jason Dowdell" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >date: Thu, 18 Apr 2002 18:14:51 -0400 > >Hi All, > >I'm encrypting an integer using the encrypt() function >in CF. Sometimes it puts a double quote character in >the encrypted string. So when I put that value in a hidden >form field it looks something like this... > >value="jd0"9em" > >Of course you can see what happens. The browser sees the >second double quote and disregards the rest of the value of >the variable. I don't have the option of storing a hashed >value as the primary key because the db is already designed. > >Does anyone have any workarounds for this? > >Thanks, >Jason >- >Jason Dowdell >Engine Studio Inc. >www.EngineStudio.com >[EMAIL PROTECTED] >- > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SP pulling my hair out!!!
Glad that helped! SQL is really picky about what you can call a "Date" but if you call it a "Char", SQL is usually pretty good at figuring it out. Chris -- Original Message From: "Neil H."<[EMAIL PROTECTED]> Subject: Re: SP pulling my hair out!!! Date: Tue, 16 Apr 2002 15:40:51 -0400 >It was not addressed and you are the man! How in the world was I supposed >to know it has to be CHAR?! That seems so backwards. I guess the >CF_SQL_DATE is for another DB server?! > >Thanks, > >Neil > >- Original Message - >From: "Chris Terrebonne " <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, April 16, 2002 3:14 PM >Subject: Re: SP pulling my hair out!!! > > >> Not sure if this has been addressed yet but you should be able to send the >> date as a CHAR and have SQL determine if its a date: >> >> > value="#DateFormat(Now(), "mm/dd/")#"> >> >> @DateValue varchar(10) >> >> As long as the date is formated properly, SQL will accept a char/varchar >as >> a datetime value. >> >> HTH, >> Chris >> >> -- >> Original Message >> From: "Neil H."<[EMAIL PROTECTED]> >> Subject: Re: SP pulling my hair out!!! >> Date: Tue, 16 Apr 2002 15:05:01 -0400 >> >> >Anyone have any code samples of CFSTOREDPROC and date usage. I just >can't >> >get it to work! >> > >> >Neil >> > >> >- Original Message - >> >From: "Neil H." <[EMAIL PROTECTED]> >> >To: "CF-Talk" <[EMAIL PROTECTED]> >> >Sent: Tuesday, April 16, 2002 2:19 PM >> >Subject: Re: SP pulling my hair out!!! >> > >> > >> >> I receive this error when I readded it: >> >> >> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: text >> is >> >> incompatible with int >> >> >> >> Neil >> >> >> >> - Original Message - >> >> From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> >> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> >> Sent: Tuesday, April 16, 2002 11:07 AM >> >> Subject: RE: SP pulling my hair out!!! >> >> >> >> >> >> > Excellent. I'm glad it's working for you. Yes it is strange. From >the >> >> > command line (query analyzer) you can put '5/26/2002' and SQL will >> >> > automatically parse it. But the ODBC driver cannot differentiate >that >> >> > syntax from string syntax - it doesn't automatically parse it as a >date >> >> just >> >> > because you've identified it as a date. I've always thought that was >a >> >> bit >> >> > of an oversite. >> >> > >> >> > mark >> >> > >> >> > -Original Message- >> >> > From: Neil H. [mailto:[EMAIL PROTECTED]] >> >> > Sent: Tuesday, April 16, 2002 9:54 AM >> >> > To: CF-Talk >> >> > Subject: Re: SP pulling my hair out!!! >> >> > >> >> > >> >> > I have found this to be the problem. So a data formatted 05/26/2002 >> >will >> >> > not work I have to use CreateODBCDATE to get that to work? That >seems >> >> dumb >> >> > :) >> >> > >> >> > Neil >> >> > >> >> > - Original Message - >> >> > From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> >> >> > To: "CF-Talk" <[EMAIL PROTECTED]> >> >> > Sent: Monday, April 15, 2002 11:04 PM >> >> > Subject: RE: SP pulling my hair out!!! >> >> > >> >> > >> >> > > Neil, >> >> > > >> >> > > I usually use #createodbcdatetime(var)# or #createodbcdate(var)# to >> >> > > correctly format the date string. >> >> > > >> >> > > Mark >> >> > > >> >> > > -Original Message- >> >> > > From: Neil H. [mailto:[EMAIL PROTECTED]] >> >> > > Sent: Monday, April 15, 2002 9:50 PM >> >> > > To: CF-Talk >> >> > > Subject: Re: SP pulling my hair out!!! >> >> > > >> >&g
Re: SP pulling my hair out!!!
Not sure if this has been addressed yet but you should be able to send the date as a CHAR and have SQL determine if its a date: @DateValue varchar(10) As long as the date is formated properly, SQL will accept a char/varchar as a datetime value. HTH, Chris -- Original Message From: "Neil H."<[EMAIL PROTECTED]> Subject: Re: SP pulling my hair out!!! Date: Tue, 16 Apr 2002 15:05:01 -0400 >Anyone have any code samples of CFSTOREDPROC and date usage. I just can't >get it to work! > >Neil > >- Original Message - >From: "Neil H." <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Tuesday, April 16, 2002 2:19 PM >Subject: Re: SP pulling my hair out!!! > > >> I receive this error when I readded it: >> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: text is >> incompatible with int >> >> Neil >> >> - Original Message - >> From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Tuesday, April 16, 2002 11:07 AM >> Subject: RE: SP pulling my hair out!!! >> >> >> > Excellent. I'm glad it's working for you. Yes it is strange. From the >> > command line (query analyzer) you can put '5/26/2002' and SQL will >> > automatically parse it. But the ODBC driver cannot differentiate that >> > syntax from string syntax - it doesn't automatically parse it as a date >> just >> > because you've identified it as a date. I've always thought that was a >> bit >> > of an oversite. >> > >> > mark >> > >> > -Original Message- >> > From: Neil H. [mailto:[EMAIL PROTECTED]] >> > Sent: Tuesday, April 16, 2002 9:54 AM >> > To: CF-Talk >> > Subject: Re: SP pulling my hair out!!! >> > >> > >> > I have found this to be the problem. So a data formatted 05/26/2002 >will >> > not work I have to use CreateODBCDATE to get that to work? That seems >> dumb >> > :) >> > >> > Neil >> > >> > - Original Message - >> > From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> >> > To: "CF-Talk" <[EMAIL PROTECTED]> >> > Sent: Monday, April 15, 2002 11:04 PM >> > Subject: RE: SP pulling my hair out!!! >> > >> > >> > > Neil, >> > > >> > > I usually use #createodbcdatetime(var)# or #createodbcdate(var)# to >> > > correctly format the date string. >> > > >> > > Mark >> > > >> > > -Original Message- >> > > From: Neil H. [mailto:[EMAIL PROTECTED]] >> > > Sent: Monday, April 15, 2002 9:50 PM >> > > To: CF-Talk >> > > Subject: Re: SP pulling my hair out!!! >> > > >> > > >> > > > variable="3" >> > > value="#3#"> >> > > @3 datetime, >> > > >> > > >> > > This is the culprit. What is the normal way to handle this?! >> > > >> > > Neil >> > > >> > > >> > > >> > > Original Message - >> > > From: "Neil H." <[EMAIL PROTECTED]> >> > > To: "CF-Talk" <[EMAIL PROTECTED]> >> > > Sent: Monday, April 15, 2002 10:33 PM >> > > Subject: Re: SP pulling my hair out!!! >> > > >> > > >> > > > >> > > > variable="1" >> > > > value="#1#"> >> > > > variable="2" >> > > > value="#2#"> >> > > > > > variable="3" >> > > > value="#3#"> >> > > > variable="4" >> > > > value="#4#"> >> > > > variable="5" >> > > > value="#5#"> >> > > > variable="6" >> > > > value="#6#"> >> > > > variable="7" >> > > > value="#7#"> >> > > > > > > > value="#8#"> >> > > > > > > > value="#9#"> >> > > > > > > > value="#10#"> >> > > > > > > > dbvarname="@11"> >> > > > >> > > > >> > > > >> > > > IF EXISTS (SELECT name FROM sysobjects >> > > > >> > > > WHERE name = 'sp_MYSP' AND type = 'P') >> > > > >> > > > DROP PROCEDURE sp_MYSP >> > > > >> > > > GO >> > > > >> > > > CREATE PROCEDURE sp_MYSP >> > > >@1 int, >> > > >@2 money, >> > > >@3 datetime, >> > > >@4 int, >> > > >@5 varchar(100), >> > > >@6 varchar(30), >> > > >@7 varchar(30), >> > > >@8 int, >> > > >@9 int, >> > > >@10 int, >> > > >@11 int OUT >> > > > >> > > > >> > > > Names were changed to protect the innocent >> > > > >> > > > Neil >> > > > >> > > > - Original Message - >> > > > From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> >> > > > To: "CF-Talk" <[EMAIL PROTECTED]> >> > > > Sent: Monday, April 15, 2002 10:02 PM >> > > > Subject: RE: SP pulling my hair out!!! >> > > > >> > > > >> > > > > Neil, >> > > > > >> > > > > better post your code - hard to deal with this error without >looking >> > at >> > > > it. >> > > > > >> > > > > Mark >> > > > > >> > > > > -Original Message- >> > > > > From: Neil H. [mailto:[EMAIL PROTECTED]] >> > > > > Sent: Monday, April 15, 2002 8:46 PM >> > > > > To: CF-Talk >> > > > > Subject: SP pulling my hair out!!! >> > > > > >> > > > > >> > > > > I only have a little hair left so PLEASE throw ideas at me! >> > > > > >> > > > > I get this error: >> > > > > >> > > > > Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax >> > error >> > > > > Hint: The cause of this error is usually that your query contains >a >> > > > > reference to a field which does not exist. You should ve
RE: Stored Procedure problem (was Stored Process)
Try this:
CREATE TABLE #x (ID int)
INSERT INTO #x (ID) VALUES(1607)
INSERT INTO #x (ID) VALUES(1627)
INSERT INTO #x (ID) VALUES(1647)
INSERT INTO #x (ID) VALUES(1667)
SELECT my_id
FROM my_table
WHERE my_table.my_id IN (SELECT ID FROM #x)
ORDER BY my_table.my_id
DROP TABLE #x
You can use many methods to automate the insert statements.
HTH,
Chris
--
Original Message
From: ""<[EMAIL PROTECTED]>
Subject: RE: Stored Procedure problem (was Stored Process)
Date: Tue, 16 Apr 2002 16:22:41 +0100
>Try using execute(@thestatement)
>
>-Original Message-
>From: Ryan Edgar [mailto:[EMAIL PROTECTED]]
>Sent: 16 April 2002 15:31
>To: CF-Talk
>Subject: RE:Stored Procedure problem (was Stored Process)
>
>
>I am working alongside Jerry on this and we are still running into
>problems.
>The Stored Proc is something like this:
>
> CREATE PROCEDURE Sp_MyProc
> DECLARE @mylist varchar(50), @thestatement varchar(255)
> SET @mylist = '1607,1627,1647,1667'
> SET @thestatement = 'SELECT my_id
> FROM my_table
> WHERE my_table.my_id IN (' +
>@mylist + ')
> ORDER BY my_table.my_id'
> EXEC Sp_MyProc@thestatement
>
>The error I get is "[ODBC SQL Server Driver][SQL Server]Error converting
>data type varchar to int"
>I cant declare @mylist as an int datatype as it is a string, but the
>database seems to expect an int datatype to be passed.
>
>If I set @mylist = 1607 and as an int datatype, I get the following
>error: "Syntax error converting the varchar value 'SELECT
>tables_colVScell.tables_cell_id FROM tables_colVScell, tables_rows WHERE
>tables_colVScell.tables_row_id IN (' to a column of data type int"
>
>Any help on this matter would be greatly appreciated as we are fairly
>stumped.
>
>TIA
>
>Ryan Edgar
>
>-Original Message-
>From: Jerry Staple
>Sent: 16 April 2002 12:12
>To: CF-Talk
>Subject: RE: Stored Process
>
>
>Thanks very Much Mike
>
>-Original Message-
>From: Mike Bruce [mailto:[EMAIL PROTECTED]]
>Sent: 16 April 2002 12:07
>To: CF-Talk
>Subject: Re: Stored Process
>
>
>Unfortunately building an 'in' statement in a stored procedure is not as
>straight forward as one would like. You can not simply pass in a list
>and
>SQL know what you are trying to do. You can, however, build the SQL
>statement and then call the spExecuteSQL to run the new SQL
>
>
>--
>CREATE PROC myStoredProc @myString varchar100
>AS
>
>DECLARE @SQLStatement
>
>SET @SQLStatement = 'select * from country where country_id in (' &
>@myString & ')'
>
>EXEC spExecuteSQL @SQLStatement
>
>
>---
>
>Check Books online to verify the syntax.
>Mike Bruce
>
>
>
>
>
>- Original Message -
>From: "Jerry Staple" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, April 16, 2002 6:52 AM
>Subject: RE: Stored Process
>
>
>> Adrian,
>> Im not sure as I am new to stored procedures.What do you think it
>should
>> be ?
>>
>>
>> -Original Message-
>> From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
>> Sent: 16 April 2002 11:43
>> To: CF-Talk
>> Subject: RE: Stored Process
>>
>>
>> cfsqltype="CF_SQL_INTEGER" is that correct??
>>
>> -Original Message-
>> From: Jerry Staple [mailto:[EMAIL PROTECTED]]
>> Sent: 16 April 2002 11:31
>> To: CF-Talk
>> Subject: Stored Process
>>
>>
>> Hi ,
>> I am transferring few queries into stored procedures but I have
>> come across a stumbling block, and would be grateful if anyone could
>> advise, for example:
>>
>> I am gathering a list of all countries on one page and sending them to
>> the action page as a list, what I have is a query select * from
>country
>> where country_id in (#url.countries#). This works fine in cfquery of
>> course, but when I put it into a stored procedure it doesn't like the
>> list of id's being passed in and only expects one value.
>>
>> I.E.
>>
>> > procedure="sp_countries"
>> datasource="geographical"
>> RETURNCODE="YES"
>> >
>> > dbvarname="@country"
>> value="#url.countries#"
>> cfsqltype="CF_SQL_INTEGER">
>>
>>
>>
>>
>>
>>
>>
>>
>> You may be thinking what would I want to put this in a stored
>procedure
>> for, but above is only an example but the principle is what im after.
>> How do you pass a list into a stored procedure.
>>
>> Many Thanks In advance
>>
>> Jerry Staple
>> Web Application Developer
>> Certified Coldfusion (5.0) Developer
>>
>>
>> Head Office
>> 133-137 Lisburn Road, Belfast
>> Northern Ireland BT9 7AG
>> T +44 (0) 28 9022 3224
>> F +44 (0) 28 9022 3223
>> E [EMAIL PROTECTED]
>> W www.biznet-solutions.com
>>
>>
>>
>>
>
>
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://ww
RE: SQL Statement dumping data
TRUNCATE TABLE MyTable Chris -- Original Message From: "Jason Larson"<[EMAIL PROTECTED]> Subject: RE: SQL Statement dumping data Date: Fri, 8 Mar 2002 09:30:54 -0700 >What I am trying to accomplish is: > >I have a client that will be pushing up a csv file to a site and then I >will setup a autmoated task that will dump all the data in a table and >then refresh the data with the data in the csv file. > >Thanks for the quick reply >Jason > >-Original Message- >From: Clint Tredway [mailto:[EMAIL PROTECTED]] >Sent: Friday, March 08, 2002 9:26 AM >To: CF-Talk >Subject: Re: SQL Statement dumping data > >Do you mean delete all the data or Export the data? > >Clint > >- Original Message - >From: "Jason Larson" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, March 08, 2002 10:22 AM >Subject: OT: SQL Statement dumping data > > >> I was wondering if anybody had the sql statement that will allow me to >> dump all the data out of the table in a database? >> >> Thanks for the help >> Jason >> >> > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Authnet Changes
Only the TransactionID is required on credits. The address information is only required for original auths if you have the AVS settings enabled. All they did as far as the AVS changes was enabled certain fields by default. Just login and uncheck them. Chris -- Original Message From: "Neil H."<[EMAIL PROTECTED]> Subject: Re: Authnet Changes Date: Fri, 15 Feb 2002 13:04:25 -0500 >You have to submit the transaction ID for each refund and all the info >address and name and everything has to match up from the previous charge. > >Neil > >- Original Message - >From: "Christopher Olive" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, February 15, 2002 12:07 PM >Subject: RE: Authnet Changes > > >> ? >> >> really, all i saw that was necessary was to require the address fields >> in the transaction. >> >> did i miss something important? (quite possible, i'm VERY tired this >> week.) >> >> christopher olive, cto, vp of web development >> atnet solutions, inc. >> 410.931.4092 >> http://www.atnetsolutions.com >> >> >> -Original Message- >> From: Neil H. [mailto:[EMAIL PROTECTED]] >> Sent: Friday, February 15, 2002 11:39 AM >> To: CF-Talk >> Subject: Authnet Changes >> >> >> I can't believe there isn't more talk about the Authnet changes. I am in >> the >> midst of changing a bunch of code now :( >> >> Neil >> >> > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:Paymentech integration
We've done some pretty extensive integration with Paymentech. Our first move was to Authorize.net, but as of late thier stability is a huge issue. The gateway goes down several times a day and forget about getting anyone on the phone never happen. We are in the process of switching to either Plug n' Pay (www.plugnpay.com) or iTransact (www.itransact.com). Both are good, work with paymentech and have CFX tags pre-build for thier individual api's. At this point we are leaning toward Plug n' Pay. Below is a copy and paste from a spreadsheet I was using to compare the prices of the 2. iTransact Plug n' Pay Transaction Fee $0.10 $0.09 Monthly Fee $24.95 $20.00 Free Monthly Transactions 500 1000 Setup Fee $295.00 $295.00 Projected Number of Transactions5,000.00 Total Monthly Cost $474.95 $380.00 Hope that helps, Chris -- Original Message From: "Howie Hamlin"<[EMAIL PROTECTED]> Subject: Paymentech integration Date: Tue, 22 Jan 2002 09:58:56 -0500 >Does anyone have any experience integrating on-line transactions with Paymentech? If so, I'd appreciate >some guidance. > >Thanks! > >-- >Howie Hamlin - inFusion Project Manager >On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 >inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing Credit Cards
Here is a free CFX tag that used 3DES encryption and hex encodes the results for URL safe transfer. Very fast and very secure. http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm Chris -- Original Message From: "Dave Watts"<[EMAIL PROTECTED]> Subject: RE: Storing Credit Cards Date: Thu, 4 Oct 2001 11:33:38 -0400 >> I have used CF_PGP on several clients and it works quite >> well. You could probably use some sort of ASP PGP COM object >> with CF instead of paying the $400 for CF_PGP. > >I believe that if you use PGP on the server, you're legally required to pay >the license costs, which are significantly more than $400. I believe it's >around $6,000 or so. > >There are plenty of significantly cheaper effective server-side encryption >options and libraries available. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing Credit Cards
Here is a free CFX tag that used 3DES encryption and hex encodes the results for URL safe transfer. Very fast and very secure. http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm Chris -- Original Message From: "Dave Watts"<[EMAIL PROTECTED]> Subject: RE: Storing Credit Cards Date: Thu, 4 Oct 2001 11:33:38 -0400 >> I have used CF_PGP on several clients and it works quite >> well. You could probably use some sort of ASP PGP COM object >> with CF instead of paying the $400 for CF_PGP. > >I believe that if you use PGP on the server, you're legally required to pay >the license costs, which are significantly more than $400. I believe it's >around $6,000 or so. > >There are plenty of significantly cheaper effective server-side encryption >options and libraries available. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing Credit Cards
Here is a free CFX tag that used 3DES encryption and hex encodes the results for URL safe transfer. Very fast and very secure. http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm Chris -- Original Message From: "Dave Watts"<[EMAIL PROTECTED]> Subject: RE: Storing Credit Cards Date: Thu, 4 Oct 2001 11:33:38 -0400 >> I have used CF_PGP on several clients and it works quite >> well. You could probably use some sort of ASP PGP COM object >> with CF instead of paying the $400 for CF_PGP. > >I believe that if you use PGP on the server, you're legally required to pay >the license costs, which are significantly more than $400. I believe it's >around $6,000 or so. > >There are plenty of significantly cheaper effective server-side encryption >options and libraries available. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database Design Challenge!
Here is a sp I used for a forum application. It doesn't require nested loops and is VERY fast. You will have to adjust it for your needs, but it should be pretty easy. --CREATE PROCEDURE expand (@current int) as DECLARE @current int DECLARE @level int, @line char(20) DECLARE @Pos int DECLARE @PrevReplyTo int CREATE TABLE #stack (item int, Thislevel int) CREATE TABLE #x (ID int, Name varchar(256), DateCreated datetime, InReplyTo int, Topic int, TotalReply int, Creator int, IsTop bit, Root int, TopDate datetime, _USER_ID int, MessageFrom varchar(256),ThisLevel int, Position int) CREATE TABLE #y (ID int, InReplyTo int, Root int) SET @current = 94 SET @Pos = 0 SET @PrevReplyTo = @current INSERT #y SELECT ID,InReplyTo, Root FROM Threads WHERE Root = @current ORDER BY DateCreated DESC INSERT #x SELECT Threads.ID AS "ID", Threads.Name AS "Name", Threads.DateCreated AS "DateCreated", Threads.InReplyTo AS "InReplyTo", Threads.Topic AS "Topic", Threads.TotalReply AS "TotalReply", Threads.Creator AS "Creator", Threads.IsTop AS "IsTop", Threads.Root AS "Root", Threads.TopDate AS "TopDate", Users.ID AS "_USER_ID", Users.Userid AS "MessageFrom", 0, 0 FROM Threads,Users WHERE Threads.Root = @current AND Threads.Creator = Users.ID SET NOCOUNT ON INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level > 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE Thislevel = @level) BEGIN -- If an item on the stack exists at this level, grab it SELECT @current = item FROM #stack WHERE Thislevel = @level -- Increment the position SET @Pos = @Pos + 1 -- Update the table with the new position UPDATE #x SET Position = @Pos, ThisLevel = @level - 1 WHERE ID = @current -- Delete this entry from the temp table (#y) DELETE FROM #y WHERE ID = @current -- Delete this entry from the stack DELETE FROM #stack WHERE Thislevel = @level AND item = @current -- Insert into the stack any IDs that are replies to the CURRENT ID INSERT #stack SELECT ID, @level + 1 FROM #y WHERE InReplyTo = @current -- If any were found, increment the level IF @@ROWCOUNT > 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 IF ((SELECT COUNT(*) FROM #y) > 0 AND (SELECT COUNT(*) FROM #stack) = 0) BEGIN IF @level = 0 SELECT @level = @level + 1 INSERT #stack SELECT ID, @level + 1 FROM #y SELECT * FROM #stack END END -- WHILE /* IF EXISTS(SELECT ID FROM #y) BEGIN UPDATE #x SET Position = @Pos + 1, ThisLevel = 1 WHERE Position = 0 AND ThisLevel = 0 UPDATE #x SET Position = @Pos + 1 WHERE Position = 0 END */ DROP TABLE #stack SELECT ID,Name,ThisLevel,Position FROM #x ORDER BY Position,DateCreated DROP TABLE #x DROP TABLE #y -- Original Message From: "Jeffry Houser"<[EMAIL PROTECTED]> Subject: Re: Database Design Challenge! Date: Thu, 17 May 2001 11:27:21 -0700 > > I was struggling with a similar situation a while back, I don't know if >I posted the query to the list (if I did, I didn't get any >responses). Unfortunately, I don't know of a way to do it other than >looping. I suspect this can be done via a stored procedure, but those are >not my area of expertise. (anyone? Anyone?) I don't know if they have >any looping functionalities. > > However, I was able to mock something up using a Query of a Query >feature of CF 5.0. It increased performance about 3 times, I believe, but >the further down you were into the table the bigger the performance increase. > >Query the database to get the whole table. > >set tempID = mycurrentD >loop until fatherID = 0 > query the query to get record where fatherID = tempID > set tempID = querythequery.uniqueD >endloop > > > That's the basic algorithm (off the top of my head), but I bet you >already knew that. > >At 10:30 AM 05/17/2001 -0400, you wrote: >>If anyone can solve this one, I'll give you a million >>bucks. Or maybe not, but I'll certainly be impressed... >> >>Let's say, for instance, I'm storing data about a family >>tree. Every person has a record in the People table. Every >>person has a Mother and a Father, linked with their unique >>ID. >> >>Now the challenge: How can I create the list of all male >>ancestors, all the way bac
Re:Find position in a list
James, I am attaching a CFX tag I wrote that will do what you need. It's called ListGetChunk and it allows you to extract a portion of a list. You could use it like this: Hope that helps, Chris -- Original Message From: "James Maltby"<[EMAIL PROTECTED]> Subject: Find position in a list Date: Fri, 23 Mar 2001 14:28:16 - >Hi > >Let's imagine I've got a list of id numbers and a specific id number within >this list. How could I output the "next" id number in the list and the >"previous" id number in the list, depending on the id number I have? > >e.g. List = 23,24,27,30,543,675,980 AND id=543 - I need to get either 30 or >675, then if I get 675 I need to get 543 or 980, etc. etc. > >TIA > >James > >"The Force is strong in this one..." > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:CFFILE Delete then WRITE issue....
You are encountering file locking errors. The write is trying to begin before the delete has released it's lock on the file. When writing and deleting, I always rename the file first, then delete the renamed file. Same for the write. Write to a temp file, then once the write is complete, rename that to it's proper name. Chris -- Original Message From: ""<[EMAIL PROTECTED]> Subject: CFFILE Delete then WRITE issue Date: Tue, 09 Jan 2001 10:53:23 -0600 > >OK. I am having a problem here. I am able to DELETE a file with CFFILE >without a problem, but when I try to almost immediately WRITE the same file >back it tells me there is an issue with the file "Error: The file could not >be accessed." Has anyone encountered this before? When I check on the >server for the file, what once was a 500k file, is now only 500 bytes, but >when I try to open it there it tells me that the "file could not be found." >But it exists. And then I have to wait a while to get the OS to release >it. I check it 24 hours later (because I am working on other things too, >and I so sleep some), and it works fine. I think this is an issue if >someone tries to OPEN the file instead of SAVING it. So the second >question is is there a way to force someone to DOWNLOAD the file instead of >opening it? > >Also, when I browse that directory in CF Studio, the file name has a RED >DOT to the left, and I have never seen this before. > >Any help would be MOST appreciated. > >Vance Duke >Cold Fusion Application Developer >i2 Technologies >(469) 357-4729 > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Email Type Detection
You will need to find a program (script, cfx, com) that will allow you to send messages as multipart/alternative. That way you can set a text/plain part and a text/html part. This will allow you to send a message using both text and html and the mail client will determine which it is capable of displaying. If you are trying to determine this based on the headers of a previous message that you have received from a mail client. You should look in the header for either Mime-Version: 1.0 or Content-Type: multipart/alternative or Content-Type: text/html Chris -- Original Message From: "Howie Hamlin"<[EMAIL PROTECTED]> Subject: Re: Email Type Detection Date: Fri, 29 Dec 2000 10:05:59 -0500 >The only way I know of is to read the X-Mailer header if it exists. Some >mailers (like Eudora or Outlook Express) add this heqader to mail. Here is >an example: > >X-Mailer: Microsoft Outlook Express 5.50.4133.2400 > >HTH (hope this helps ) > >Regards, > >Howie > >- Original Message - >From: <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, December 29, 2000 9:53 AM >Subject: Email Type Detection > > >> Does anyone know how one would go about finding out whether a user's email >> accepts html mail or just plain text? I know that some companies have >> incorporated this into their mass emails but I can't figure it out for the >> life of me. Thanks. >> >> Lisa >> >> >> >> > ~ Paid Sponsorship ~ Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit SoloServer, https://secure.irides.com/clientsetup.cfm. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:HTMl:Border Around Tables
Some Content -- Original Message From: ""<[EMAIL PROTECTED]> Subject: HTMl:Border Around Tables Date: Fri, 15 Dec 2000 13:05:01 -0500 (EST) > >I have been struggling with this one for quite some time >now: I need a one pixel border around the OUTSIDE of a >table. Here's my most recent attempt: > >Enclose the table within another table. Set the >cellspacing of this "outer" table to one pixel and give >the specified BGCOLOR. > >This works fine in IE, but Netscape displays a two-pixel >border on the top & left edges, with no border on the >bottom & right edges. > >Does anyone else have a solution? I'm trying to avoid >CSS since I can't guarantee browser compatibility, >although if you know of a cross-browser CSS solution, I >would be very happy. > >Thanks! > >Norman Elton >Information Technology >College of William & Mary > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfstored procedure problem
Kill the single quotes. No need to put them around an SQL var. Chris -- Original Message From: "sebastian palmigiani"<[EMAIL PROTECTED]> Subject: Re: cfstored procedure problem Date: Tue, 05 Dec 2000 22:29:16 -0600 >on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote: > >> Hi everyone, >> >> I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5 >> >> This is my stored procedure in SQL: >> >> @SAMAccountName varchar >> >> AS >> >> SELECT UserID FROM PasUsers >> WHERE SAMAccountName = '@SAMAccountName' > >I don't know if you purposefully left it out but you need to have: > >CREATE PROCEDURE myProceduresName (@SAMAccountName varchar (field lenght) ) > > >For example: > >CREATE PROCEDURE SelectUserID ( @SAMAccountName varchar (15) ) > >AS > >etc. > >Sebastian > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:SQL 7 database transfer from one server to another
Look up the syntax for sp_dettach and sp_attach. With that you can move the db by hand with no leftovers. Chris -- Original Message From: "ryo watanabe"<[EMAIL PROTECTED]> Subject: SQL 7 database transfer from one server to another Date: Thu, 30 Nov 2000 11:27:36 -0500 >This is a multi-part message in MIME format. > >--=_NextPart_000_0038_01C05AC0.8A100420 >Content-Type: text/plain; > charset="Windows-1252" >Content-Transfer-Encoding: quoted-printable > >when I transfer a SQL database from one server to another using MSDTS, = >it ignores the datatypes. am I missing something when I use MSDTS, or = >is this a bug? > >--=_NextPart_000_0038_01C05AC0.8A100420 >Content-Type: text/html; > charset="Windows-1252" >Content-Transfer-Encoding: quoted-printable > > > >charset=3Dwindows-1252"> > > > > >when I transfer a SQL database from one server to = >another=20 >using MSDTS, it ignores the datatypes. am I missing something when = >I use=20 >MSDTS, or is this a bug? > >--=_NextPart_000_0038_01C05AC0.8A100420-- > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:SQL 7.0 Question
Yes, * is the syntax for ALL in SQL7, but you don't need to specify that for a DELETE. When you issue a delete, you delete the entire record, so there is no need to specify columns. Try: DELETE from auction_records where auction_id='#id#' and userid='#userid#' Chris -- Original Message From: "ibtoad"<[EMAIL PROTECTED]> Subject: SQL 7.0 Question Date: Thu, 30 Nov 2000 11:11:27 -0500 >Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything >works great except one statement. > > >DELETE * from auction_records where auction_id='#id#' and userid='#userid#' > > >Here is the error: > >ODBC Error Code = 37000 (Syntax error or access violation) > >[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near >'*'. > >Is * not the correct syntax for All is SQL 7.0? > >Thanks, >Rich > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query as a structure
Actually a query is an array of structures. Chris -- Original Message From: "Eric Bradburn"<[EMAIL PROTECTED]> Subject: RE: Query as a structure Date: Wed, 29 Nov 2000 11:49:38 -0500 >This message is in MIME format. Since your mail reader does not understand >this format, some or all of this message may not be legible. > >--_=_NextPart_001_01C05A24.5CDF7126 >Content-Type: text/plain; > charset="iso-8859-1" > >A Query is an Array. > >-Original Message- >From: Manam Suresh [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, November 29, 2000 11:38 AM >To: CF-Talk >Subject: Query as a structure > > >Is query a structure in CF 4.01? >How can I convert a query to a structure in CF 4.01? > >Thanks >Kumar > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >--_=_NextPart_001_01C05A24.5CDF7126 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > > > >charset=3Diso-8859-1"> >5.5.2650.12"> >RE: Query as a structure > > > >A Query is an Array. > > >-Original Message- >From: Manam Suresh [HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]ONT> >Sent: Wednesday, November 29, 2000 11:38 AM >To: CF-Talk >Subject: Query as a structure > > > >Is query a structure in CF 4.01? >How can I convert a query to a structure in CF = >4.01? > > >Thanks >Kumar > > >SIZE=3D2>~~ >Structure your ColdFusion code with Fusebox. Get the = >official book at http://www.fusionauthority.com/bkinfo.cfm" = >TARGET=3D"_blank">http://www.fusionauthority.com/bkinfo.cfm > > >Archives: HREF=3D"http://www.mail-archive.com/cf-talk@houseoffusion.com/" = >TARGET=3D"_blank">http://www.mail-archive.com/cf-talk@houseoffusion.com/= > >Unsubscribe: HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists" = >TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= > > > > > >--_=_NextPart_001_01C05A24.5CDF7126-- >~~ >Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:MS SQL Shortcut?
I havn't tested this, but you should be able to do either of the following: SELECT (Sum(paymentamt) + 0) AS total or SELECT CAST(Sum(paymentamt) AS int) AS total Chris -- Original Message From: "Jim McAtee"<[EMAIL PROTECTED]> Subject: MS SQL Shortcut? Date: Wed, 22 Nov 2000 15:14:34 -0700 >I've got a table that contains payment detail records and I've found that >something like the following workaround is necessary when adding up a column >contains the dollar amount. This query always returns a single record, but >when there are zero payment records found, the 'total' field returns a >zero-length string rather than returning 0. Of course, if I later attempt >to user that value in a CF arithmetic expression, CF chokes and gives an >'unable to convert' to numeric error. I've got a lot of these summing >queries and was wondering if there's a way within the SQL statement (MS >SQL7) to return 0 if there are no records found. > > > >SELECT Sum(paymentamt) AS total >FROM payments >WHERE userid = #form.userid# > > > > > > > > >Thanks, >Jim > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:convert kilobytes to megabytes?
-- Original Message From: "Emmet McGovern"<[EMAIL PROTECTED]> Subject: convert kilobytes to megabytes? Date: Wed, 1 Nov 2000 17:54:56 -0500 >Is there an easy way to convert byte values to megabyte values. > >ex. 9 bytes is 9k or 90 is 9m > >Thanks in advance >Emmet > >--- - >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' >in the body to [EMAIL PROTECTED] > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: ADO vs. ODBC
For other db servers, this may not be the case, but for SQL Server, ODBC is the fastest method for accessing your data. Here are some reasons, directly from MS, for using ODBC: -- While many database vendors support ODBC by using a mapping layer on top of their proprietary interface, this is not true for Microsoft SQL Server. For SQL Server, ODBC are "native" interfaces for SQL Server. (In fact, all current SQL Server TPC-C benchmarks are published using the ODBC interface, which is strong evidence of the performance of SQL Server's ODBC implementation.) ( http://msdn.microsoft.com/library/techart/designeff_choose.htm ) --The ODBC driver uses the performance features of SQL Server automatically. For example, SQL Server stored procedures can be executed using an efficient procedure call network format. DB-Library uses a separate set of APIs to send requests in the network format. ODBC uses the same APIs used for sending nonstored procedure requests and looks for the standard ODBC "call" syntax to trigger the use of this efficient network format. ( http://msdn.microsoft.com/library/techart/designeff_choose.htm ) -- Microsoft did a sample application for a PC Week benchmark Web application (Nile.com) which put their DNA architecture up against other vendors for a scalability test. The application's data was held in SQL Server 7.0 and accessed through the ODBC API. ( http://msdn.microsoft.com/library/backgrnd/html/nilewp.htm ) Chris -- Original Message From: "CT, Loo"<[EMAIL PROTECTED]> Subject: Re: ADO vs. ODBC Date: Fri, 13 Oct 2000 03:54:58 +0800 >Hi! Aymeric, > >I am working on some CF application using COM that returns ADO recordsets. I >am totally new to this and I am totally no idea how to loop through the >recordsets. Would your CD_ADO custom tag help? Can I have a copy of your >custom tag? > >Thanks, > >Regards, >Loo > >- Original Message - >From: Aymeric Grassart <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Friday, August 04, 2000 10:29 PM >Subject: Re: ADO vs. ODBC > > >> - Original Message - >> From: "Patrick Maddox" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Friday, August 04, 2000 9:07 AM >> Subject: ADO vs. ODBC >> >> >> > I am working on a project to where the client wants a CF database >> > application, however, they are >> > requesting that I do a ADO connection to the database(sql 7) vs. the >> typical >> > ODBC connection that I am >> > used to doing. >> > >> > Does anyone have info on the differences between the two connection >types. >> > What's faster, better etc. >> >> ADO is faster than CFQUERY, the only problem is that converting the >> recordset into CF query's makes it 10 times slower ; but other than that, >it >> should work. >> I have an alpha version of CF_ADO custom tag, if you'd like a copy, let me >> know. >> >> blah, >> Aymeric >> >> > and where I might go to get some additional info on this. The site will >> not >> > get huge volumes of hits, maybe >> > 200 hits on the database at any moment at the very most. >> > >> > Thank you. >> > >> > >> > *** >> > Patrick Maddox >> > Terralogic, Inc. >> > 540-213-2447 >> > [EMAIL PROTECTED] >> > >> >> -- >> >> > 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] with 'unsubscribe' in >> the body. >> > >> >> -- > >> 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] with 'unsubscribe' in >the body. >> > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re: SQL Question
This will do it: SELECT FirstName, LastName FROM RealtorInfo WHERE RealtorID IN (SELECT RealtorID FROM Homes WHERE HomeID IN(#homelist#)) Chris -- Original Message From: ""<[EMAIL PROTECTED] (paul smith)> Subject: Re: SQL Question Date: Tue, 10 Oct 2000 10:06:22 -0700 >SELECT ID FROM OtherTable WHERE blah > > >SELECT FirstName, LastName >FROM RealtorInfo >WHERE RealtorID IN (#ValueList(MyQuery.ID)# > > >best, paul > >At 12:47 PM 10/10/00 -0500, you wrote: >>I have a list of ID's and I want to query based on those ID's so I have >>SELECT * >>FROM Homes >>WHERE HomeID IN(#homelist#) >> >>Now here is the question I want to run a query that pull info from another >>table based on the results of that query >>I think I want to run something like this but I am not sure of the exact >>syntax. >> >>SELECT FirstName, LastName >>FROM RealtorInfo >>WHERE RealtorID ??? >> >>Run a another select statement that pulls the ID's of the realtor from the >>Homes table based on the homelist? >> >>If this seems confusing let me know and I will clarify , if I can. >> >>Kevin Schmidt >>Internet Services Director >>PWB Integrated Marketing and Communications >>Office: 734.995.5000 >>Mobile: 734.649.4843 >> >> >> >>-- >>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] with 'unsubscribe' in >>the body. > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: You are a stored Proc god if you can answer this...
Are you calling the stored procedure via the cfquery tag, the cfstoredproc
tag, or from within another stored procedure?
Could you post the snippet of your code that calls the procedure? That
would give us a better idea on how to work this out.
Chris
--
Original Message
From: "Mark W. Breneman"<[EMAIL PROTECTED]>
Subject: RE: You are a stored Proc god if you can answer this...
Date: Mon, 9 Oct 2000 16:34:26 -0500
>No luck...
>
>Any other ideas?
>
>Mark W. Breneman
>-Cold Fusion Developer
>-Network Administrator
> Vivid Media
> [EMAIL PROTECTED]
> www.vividmedia.com
> 608.270.9770
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 09, 2000 4:23 PM
>To: CF-Talk
>Subject: RE: You are a stored Proc god if you can answer this...
>
>
>Try:
>Search_RC1('WHERE State=''NC''')
>
>Those are 2 single quotes around the NC. You need to enclose NC in a
>single quote, but since the enire expression has to be enclosed in single
>quotes, you have to escape them with yet another pair of single quotes.
>
>Hope that helps,
>Chris
>
>--
>Original Message
>From: "Mark W. Breneman"<[EMAIL PROTECTED]>
>Subject: RE: You are a stored Proc god if you can answer this...
>Date: Mon, 9 Oct 2000 15:42:10 -0500
>
>>OK, one problem...
>>
>>How do I get around the quote problems.
>>
>>IF I try (one at a time):
>>Search_RC1("WHERE State="NC"")
>>Search_RC1('WHERE State='NC'')
>>Search_RC1("WHERE State='NC'")
>>Search_RC1('WHERE State="NC"')
>>I get:
>>Line 1: Incorrect syntax near 'WHERE State='NC''.
>>Line 1: Incorrect syntax near 'WHERE State='.
>>Line 1: Incorrect syntax near 'WHERE State='NC''.
>>Line 1: Incorrect syntax near 'WHERE State="NC"'.
>>
>>Is to possible to pass quotes to a stored proc and build a query in this
>>fashion.
>>Am I missing something?
>>
>>Thanks
>>
>>Mark W. Breneman
>>-Cold Fusion Developer
>>-Network Administrator
>> Vivid Media
>> [EMAIL PROTECTED]
>> www.vividmedia.com
>> 608.270.9770
>>
>>
>>-Original Message-
>>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, October 09, 2000 2:32 PM
>>To: CF-Talk
>>Subject: Re:You are a stored Proc god if you can answer this...
>>
>>
>>Try this:
>>
>>CREATE PROCEDURE [Search_RC] @where varchar(255)
>>AS
>>
>>DECLARE @Select varchar(255)
>>SET @Select = 'SELECT count (*) as noofrecords FROM NPO_IRS_primary ' +
>>@where
>>CREATE TABLE #x (MyCount int)
>>
>>INSERT INTO #x
>> EXECUTE(@Select)
>>
>>SELECT MyCount FROM #x
>>DROP TABLE #x
>>
>>
>>
>>
>>--
>>Original Message
>>From: "Mark W. Breneman"<[EMAIL PROTECTED]>
>>Subject: You are a stored Proc god if you can answer this...
>>Date: Mon, 9 Oct 2000 12:09:13 -0500
>>
>>>I need to do a record count with a CF generated "WHERE" statement.
>>>
>>>SELECT count (*) as noofrecords
>>>FROM xxx
>>>#PreserveSingleQuotes(searchstring)#
>>>
>>>Now I need to convert this into a stored proc.
>>>
>>>I tried:
>>>CREATE PROCEDURE [Search_RC] @where varchar(255)
>>>AS
>>>
>>>SELECT count (*) as noofrecords
>>>FROM NPO_IRS_primary
>>>@where
>>>
>>>No luck...
>>>
>>>Any one have an idea?
>>>
>>>
>>>
>>>Example of the "WHERE" statement:
>>>WHERE (State = 'NC') and ((ActivityCodeOne = '260') or (ActivityCodetwo =
>>>'260') or (ActivityCodethree = '260') or (ActivityCodeOne
>>> = '261') or (ActivityCodetwo = '261') or (ActivityCodethree = '261') or
>>>(ActivityCodeOne = '262') or (ActivityCodetwo = '262') or
>>(ActivityCodethree
>>>=
>>> '262') or (ActivityCodeOne = '263') or (ActivityCodetwo = '263') or
>>>(ActivityCodethree = '263') or (ActivityCodeOne = '264') or
>>(ActivityCodetwo
>>>=
>>> '264') or (ActivityCodethree = '264') or (A
RE: You are a stored Proc god if you can answer this...
Try:
Search_RC1('WHERE State=''NC''')
Those are 2 single quotes around the NC. You need to enclose NC in a
single quote, but since the enire expression has to be enclosed in single
quotes, you have to escape them with yet another pair of single quotes.
Hope that helps,
Chris
--
Original Message
From: "Mark W. Breneman"<[EMAIL PROTECTED]>
Subject: RE: You are a stored Proc god if you can answer this...
Date: Mon, 9 Oct 2000 15:42:10 -0500
>OK, one problem...
>
>How do I get around the quote problems.
>
>IF I try (one at a time):
>Search_RC1("WHERE State="NC"")
>Search_RC1('WHERE State='NC'')
>Search_RC1("WHERE State='NC'")
>Search_RC1('WHERE State="NC"')
>I get:
>Line 1: Incorrect syntax near 'WHERE State='NC''.
>Line 1: Incorrect syntax near 'WHERE State='.
>Line 1: Incorrect syntax near 'WHERE State='NC''.
>Line 1: Incorrect syntax near 'WHERE State="NC"'.
>
>Is to possible to pass quotes to a stored proc and build a query in this
>fashion.
>Am I missing something?
>
>Thanks
>
>Mark W. Breneman
>-Cold Fusion Developer
>-Network Administrator
> Vivid Media
> [EMAIL PROTECTED]
> www.vividmedia.com
> 608.270.9770
>
>
>-Original Message-
>From: Chris Terrebonne [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 09, 2000 2:32 PM
>To: CF-Talk
>Subject: Re:You are a stored Proc god if you can answer this...
>
>
>Try this:
>
>CREATE PROCEDURE [Search_RC] @where varchar(255)
>AS
>
>DECLARE @Select varchar(255)
>SET @Select = 'SELECT count (*) as noofrecords FROM NPO_IRS_primary ' +
>@where
>CREATE TABLE #x (MyCount int)
>
>INSERT INTO #x
> EXECUTE(@Select)
>
>SELECT MyCount FROM #x
>DROP TABLE #x
>
>
>
>
>--
>Original Message
>From: "Mark W. Breneman"<[EMAIL PROTECTED]>
>Subject: You are a stored Proc god if you can answer this...
>Date: Mon, 9 Oct 2000 12:09:13 -0500
>
>>I need to do a record count with a CF generated "WHERE" statement.
>>
>>SELECT count (*) as noofrecords
>>FROM xxx
>>#PreserveSingleQuotes(searchstring)#
>>
>>Now I need to convert this into a stored proc.
>>
>>I tried:
>>CREATE PROCEDURE [Search_RC] @where varchar(255)
>>AS
>>
>>SELECT count (*) as noofrecords
>>FROM NPO_IRS_primary
>>@where
>>
>>No luck...
>>
>>Any one have an idea?
>>
>>
>>
>>Example of the "WHERE" statement:
>>WHERE (State = 'NC') and ((ActivityCodeOne = '260') or (ActivityCodetwo =
>>'260') or (ActivityCodethree = '260') or (ActivityCodeOne
>> = '261') or (ActivityCodetwo = '261') or (ActivityCodethree = '261') or
>>(ActivityCodeOne = '262') or (ActivityCodetwo = '262') or
>(ActivityCodethree
>>=
>> '262') or (ActivityCodeOne = '263') or (ActivityCodetwo = '263') or
>>(ActivityCodethree = '263') or (ActivityCodeOne = '264') or
>(ActivityCodetwo
>>=
>> '264') or (ActivityCodethree = '264') or (ActivityCodeOne = '265') or
>>(ActivityCodetwo = '265') or (ActivityCodethree = '265') or
>(ActivityCodeOne
>>=
>> '266') or (ActivityCodetwo = '266') or (ActivityCodethree = '266') or
>>(ActivityCodeOne = '267') or (ActivityCodetwo = '267') or
>(ActivityCodethree
>>=
>> '267') or (ActivityCodeOne = '268') or (ActivityCodetwo = '268') or
>>(ActivityCodethree = '268') or (ActivityCodeOne = '269') or
>(ActivityCodetwo
>>=
>> '269') or (ActivityCodethree = '269') or (ActivityCodeOne =
>'279')
>>or (ActivityCodetwo = '279') or (ActivityCodethree = '279') )
>>
>>
>>
>>Mark W. Breneman
>>-Cold Fusion Developer
>>-Network Administrator
>> Vivid Media
>> [EMAIL PROTECTED]
>> www.vividmedia.com
>> 608.270.9770
>>
>>--
-
>---
>>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 PROTEC
Re:You are a stored Proc god if you can answer this...
Try this: CREATE PROCEDURE [Search_RC] @where varchar(255) AS DECLARE @Select varchar(255) SET @Select = 'SELECT count (*) as noofrecords FROM NPO_IRS_primary ' + @where CREATE TABLE #x (MyCount int) INSERT INTO #x EXECUTE(@Select) SELECT MyCount FROM #x DROP TABLE #x -- Original Message From: "Mark W. Breneman"<[EMAIL PROTECTED]> Subject: You are a stored Proc god if you can answer this... Date: Mon, 9 Oct 2000 12:09:13 -0500 >I need to do a record count with a CF generated "WHERE" statement. > >SELECT count (*) as noofrecords >FROM xxx >#PreserveSingleQuotes(searchstring)# > >Now I need to convert this into a stored proc. > >I tried: >CREATE PROCEDURE [Search_RC] @where varchar(255) >AS > >SELECT count (*) as noofrecords >FROM NPO_IRS_primary >@where > >No luck... > >Any one have an idea? > > > >Example of the "WHERE" statement: >WHERE (State = 'NC') and ((ActivityCodeOne = '260') or (ActivityCodetwo = >'260') or (ActivityCodethree = '260') or (ActivityCodeOne > = '261') or (ActivityCodetwo = '261') or (ActivityCodethree = '261') or >(ActivityCodeOne = '262') or (ActivityCodetwo = '262') or (ActivityCodethree >= > '262') or (ActivityCodeOne = '263') or (ActivityCodetwo = '263') or >(ActivityCodethree = '263') or (ActivityCodeOne = '264') or (ActivityCodetwo >= > '264') or (ActivityCodethree = '264') or (ActivityCodeOne = '265') or >(ActivityCodetwo = '265') or (ActivityCodethree = '265') or (ActivityCodeOne >= > '266') or (ActivityCodetwo = '266') or (ActivityCodethree = '266') or >(ActivityCodeOne = '267') or (ActivityCodetwo = '267') or (ActivityCodethree >= > '267') or (ActivityCodeOne = '268') or (ActivityCodetwo = '268') or >(ActivityCodethree = '268') or (ActivityCodeOne = '269') or (ActivityCodetwo >= > '269') or (ActivityCodethree = '269') or (ActivityCodeOne = '279') >or (ActivityCodetwo = '279') or (ActivityCodethree = '279') ) > > > >Mark W. Breneman >-Cold Fusion Developer >-Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re:OT: SQL Server
text -- Original Message From: "Andy Peterson"<[EMAIL PROTECTED]> Subject: OT: SQL Server Date: Thu, 5 Oct 2000 13:15:41 -0500 >Hi, > >Can anyone tell me what the equivalent of a MS Access "memo" field is in SQL >Server 7.0? > >TIA, >Andy > > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: HTML Email Tracking
In the CFM file, you can do either of these: Use this if the image doesn't reside on your server. or, use this if the image is on your server Chris -- Original Message From: "Gavin Myers"<[EMAIL PROTECTED]> Subject: RE: HTML Email Tracking Date: Thu, 5 Oct 2000 12:02:07 -0500 >i don't think you can do anything in an html e-mail campaign other then >html. Even javascript wont work 98% of the time. What about setting the >images you are going to use aside from the rest of your web directory like >put them in >www.mydomain.com/htmlemailcampaign/imagepool/ >link them to the html document and use web trends to track each time those >images get hit? > >-Original Message- >From: Sean Daniels [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 05, 2000 11:29 AM >To: CF-Talk >Subject: HTML Email Tracking > > >I feel like I've seen this done before, but I can't for the life of me >figure out how to get it to work. > >What I have is a marketing email that is going out HTML formatted. I want to >include in it a reference to an image file. I've heard that some people have >successfully referenced a CFM file in the src of the image that would allow >you to have some code executed each time the image was grabbed. Then you use >cfcontent maybe to push out an actual image. > >Anyone got some code that shows how this is actually done? I've tried just: > > > >The code in thefile.cfm doesn't get run though. All it does by the way is >increment a counter in a db table. > >TIA > >- Sean > >~~ > Sean Daniels > Manager, Engineering > (T): 207.439.6030 > (C): 978.764.0799 >~~ > http://www.dealforce.com > http://www.mergernetwork.com > > > >--- - >-- >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] with 'unsubscribe' in >the body. >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re: Moving SQL to new server
Look up the "sp_attach" and "sp_detach" procedures. You will need to install SQL on the new server, then sp_detach the databases that you wish to transfer. Copy the mbf and ldf files to the new server, then use sp_attach to "add" the db's to the new installation. Chris -- Original Message From: "CF-Talk"<[EMAIL PROTECTED]> Subject: Re: Moving SQL to new server Date: Wed, 4 Oct 2000 23:34:24 +0200 >In MS-SQL-Server 6.5 there was a feature called Transfer Manager. >You could have used it to transfer data, structure and data or only the >structure of DBs in both directions. >Either from the old server to the new or vice versa. >Although you have to install the devices and DBs first on the new mchine. >Uwe >- Original Message - >From: "Dave Watts" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Mittwoch, 4. Oktober 2000 21:39 >Subject: RE: Moving SQL to new server > > >> That still results in the same error. I even went so far as >> to create a new database, use DTS to transfer all objects and >> data, create a backup with the same name, replace that back >> up with the backup from the source and I still got an error >> saying it's a different database. If I select "force restore >> over existing database" I get the "with move" error. When I >> examine the path that you mentioned it points to the correct drive. >> Others have mentioned using DTS. Are there any pitfalls to >> this? I'm glad I'm not in a crisis recovery situation. > >You can use DTS for this to simply transfer the data from one server to >another, but I've had better success with the backup/restore method - it >generally is faster, and produces fewer inscrutable errors in my experience. >If you like, simply delete the existing database on the server to which you >want to restore, then try the restore - then, the database will be created >from scratch. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 >--- - >-- >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] with 'unsubscribe' in >the body. > > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re: cf error question...
Thanks for the response.
I understand how to use CFTRY/CFCATCH and CFERROR. The messages that I am
trying to replace are the CF server errors messages like: "Request canceled
or igorned by server", etc..
Those types of messages are not affected by try/catch or cferror.
Any ideas?
Thanks,
Chris
--
Original Message
From: "Jamie Keane"<[EMAIL PROTECTED]>
Subject: Re: cf error question...
Date: Wed, 6 Sep 2000 08:57:14 -0400
>I assume you mean the error messages with the diagnostic information in a
>box (syntax error, ODBC error, etc.)? The way you can set a default
>alternative for these admittedly ugly errors is to use the CFERROR tag in
>your application.cfm. If that's too limiting for what you wanted to do,
you
>could use CFTRY/CFCATCH to trap individual errors per page and manipulate
>them.
>
>--
>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: Chris Terrebonne <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>Date: Tuesday, September 05, 2000 6:15 PM
>Subject: cf error question...
>
>
>>This has probably been covered already but...
>>Is there any way to replace or customize CF's internal error messages
>>("canceled or ignored by server...", etc)?
>>
>>Thanks,
>>Chris
>>
>>_
>>Free email with personality! Over 200 domains!
>>http://www.MyOwnEmail.com
>>
>>--
-
>---
>>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] with 'unsubscribe' in
>the body.
>
>---
---
>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] with 'unsubscribe' in
the body.
>
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
--
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] with 'unsubscribe' in the body.
cf error question...
This has probably been covered already but...
Is there any way to replace or customize CF's internal error messages
("canceled or ignored by server...", etc)?
Thanks,
Chris
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
--
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] with 'unsubscribe' in the body.
Re:OT SQL 7 FULL-TEXT more than one column?
Here are two sql statements that I use for a forums app. Both use multiple columns: SELECT TOP 300 ID,Name,Catagory,Description,TotalThreads,TotalTopics,IsPrivate,WebName,KeyW ords,KEY_TBL.RANK FROM Forums AS FT_TBL, FREETEXTTABLE(Forums, *,'#SearchString#') AS KEY_TBL WHERE FT_TBL.ID = KEY_TBL.[KEY] AND IsPrivate = 0 ORDER BY KEY_TBL.RANK DESC SELECT TOP 300 FT_TBL.ID, FT_TBL.Name, FT_TBL.Body, FT_TBL.TotalReply, FT_TBL.Topic, FT_TBL.DateCreated, KEY_TBL.RANK FROM Threads AS FT_TBL, FREETEXTTABLE(Threads, *,'#SearchString#') AS KEY_TBL WHERE FT_TBL.ID = KEY_TBL.[KEY] AND FT_TBL.IsArchived = 0 AND (SELECT IsPrivate FROM Forums WHERE ID = (SELECT Forum FROM Topics WHERE ID = FT_TBL.Topic)) = 0 ORDER BY KEY_TBL.RANK DESC -- Original Message From: "PC"<[EMAIL PROTECTED]> Subject: OT SQL 7 FULL-TEXT more than one column? Date: Tue, 05 Sep 2000 12:44:52 -0700 >I know you can assign more than one column in setting up a fulltext index >on a table -- but it seems like you can't include more than one column in >the where CONTAINS statement...if this is indeed true how do you create a >query to search thru all of the columns you have included in the fulltext >indexing of a given table? An example would be highly appreciated! > >TIA > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: SQL ORDER BY Problem
I meant to include the SQL DateDiff() function. Oopps, sorry... Here's the correct way: SELECT Date, DateDiff(DAY,Date, GetDate()) AS "DateSpan" FROM Dates ORDER BY DateSpan Chris -- Original Message From: "Dan Haley"<[EMAIL PROTECTED]> Subject: RE: SQL ORDER BY Problem Date: Tue, 5 Sep 2000 09:58:08 -0700 >This one, just like James' original won't work because you are mixing CF and >SQL statements. CF will try to evaluate the '#datediff(date, now())#' one >time when it is preparing the SQL to send to the database. It will not be >evaluated for each row of the query. Build your query with CF. Use SQL >statements and functions for manipulating each row of the query. > >Dan > >-Original Message- >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, September 05, 2000 9:45 AM >To: [EMAIL PROTECTED] >Subject: Re: SQL ORDER BY Problem > > >SELECT Date, #DateDiff(date, now())# AS "DateSpan" >FROM Dates >ORDER BY DateSpan > > >chris > >-- >Original Message >From: "David Shadovitz"<[EMAIL PROTECTED]> >Subject: Re: SQL ORDER BY Problem >Date: Tue, 5 Sep 2000 06:18:33 -0700 > >>Wouldn't your results be the same if you just ordered by Date? You're >>merely (trying to) subtract a constant from each Date. >>-David >> >>On Tue, 5 Sep 2000 "James Smith" <[EMAIL PROTECTED]> writes: >>> I have a query that selects dates from a datasource, and I would like >>> to >>> order by the number of days to the next occurrence, but the >>> following >>> doesn't work. >>> >>> SELECT Date >>> FROM Dates >>> ORDER BY #DateDiff(date, now())# >> >>YOU'RE PAYING TOO MUCH FOR THE INTERNET! >>Juno now offers FREE Internet Access! >>Try it today - there's no risk! For your FREE software, visit: >>http://dl.www.juno.com/get/tagj. >>-- - >--- >>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] with 'unsubscribe' in >the body. >> > >_ >Free email with personality! Over 200 domains! >http://www.MyOwnEmail.com > >--- - >-- >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] with 'unsubscribe' in >the body. >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re: SQL ORDER BY Problem
SELECT Date, #DateDiff(date, now())# AS "DateSpan" FROM Dates ORDER BY DateSpan chris -- Original Message From: "David Shadovitz"<[EMAIL PROTECTED]> Subject: Re: SQL ORDER BY Problem Date: Tue, 5 Sep 2000 06:18:33 -0700 >Wouldn't your results be the same if you just ordered by Date? You're >merely (trying to) subtract a constant from each Date. >-David > >On Tue, 5 Sep 2000 "James Smith" <[EMAIL PROTECTED]> writes: >> I have a query that selects dates from a datasource, and I would like >> to >> order by the number of days to the next occurrence, but the >> following >> doesn't work. >> >> SELECT Date >> FROM Dates >> ORDER BY #DateDiff(date, now())# > >YOU'RE PAYING TOO MUCH FOR THE INTERNET! >Juno now offers FREE Internet Access! >Try it today - there's no risk! For your FREE software, visit: >http://dl.www.juno.com/get/tagj. >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: Does Cold Fusion Chug?
Cold Fusion DOES have scalability issues. Sure, if you throw enough servers at it, it will scale...but the same can be said for virtual any language. Don't get me wrong, CF is a very robust language, but the fact is there are issues. imho, Chris -- Original Message From: "Jeremy Allen"<[EMAIL PROTECTED]> Subject: RE: Does Cold Fusion Chug? Date: Thu, 17 Aug 2000 15:19:09 -0400 >That is totally NOT true. > >To write a scaleable app it takes knowledge >beyond even writing clean CF that scales. > >That is an important part, if an app is >not written well it wont scale.. period. > >If the hardware is not setup well. >It wont scale. > >If the entire system (read:software/hardware) >is written with scalability in mind then a >CF Solution more than arises to the task.. > >Even on NT machines if you toss enough of >them into your load balanced cluster. > >ColdFusion does run on Solaris so if you just >wanted some really hardcore hardware like E10K >and you have to cash to spare then ColdFusion >can run their. > >ColdFusion *does* scale :) > > >Jeremy Allen >[EMAIL PROTECTED] >[Insert cool title here] > >-Original Message- >From: Gavin Myers [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 17, 2000 3:15 PM >To: '[EMAIL PROTECTED]' >Subject: Does Cold Fusion Chug? > > >Okay, I am a big fan of CF but every now and then I hear about how cold >fusion doesn't work well with high volume sites... I'm not sure if this is >just a rumour. Does anyone have any documents about this, or is it just a >rumour? > >I'm under the belief that it doesnt matter wether you have asp, java, cf as >your main code, and it has more to do with how well your server can handle >the multiple file/database requests. >--- - >-- >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] with 'unsubscribe' in >the body. > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: oledb and native drivers
I used one clean machine with fresh installs of NT, CF, and SQL 7. I used the same db and set up 2 connections, one ODBC (AdServer) and one OLEDB (AdServer_o). I then ran a single query on a static data set 20 times for each and averaged the execution time for each. This was repeated 10 + times (I say + because I didn't believe the results at first, so I gave it a few more runs). The data contained current campaign information from the existing ad server that were dumped to the new db. The test was to select random campaign banners for return to the client process. Again, I was testing everything I could think of to get the best performance possible. I'm also not a newbie with my first copy of sql/cf, so I have a very solid understanding of how to contruct performance minded queries. I was satisfied enough with my results to stick with ODBC, and this ad server is serving over 40 million impressions a month, so I wasn't "benchmarking" just for the sake of it. You of course are free to do whatever tests you like. The above served my purpose, and maybe it will save others the time and effort. Chris -- Original Message From: "Jeremy Allen"<[EMAIL PROTECTED]> Subject: RE: oledb and native drivers Date: Thu, 3 Aug 2000 11:56:03 -0400 >Just to throw this out.. Most any benchmarking people do is not >really 'clean'. > >I am not discrediting your benchmarking methodology but. > >However in order to really clear my concious and say one is faster.. > > >..I would want to seperate machines totally fresh installs of NT >CF, and SQL. > >..The same data set used on each data souce. > >..and a whole lot of things you do standard benchmakring > >And OLE DB is reported to be somewhat faster, as I have read >in the CFDJ the author put up no hard numbers but more or less >stated that OLE DB was faster. I still am not sure, and would >like to see some rigirous becnhmarks to settle this.. So >If you could explain exactly how you obtained the benchmarks >I would love to hear it :) > >There are four types of lies (In order from best to worst :) > >Lies, Damn Lies, Statistics, Benchmarks > > > >Jeremy Allen >[EMAIL PROTECTED] >[Insert cool title here] > > > > >-Original Message- >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 10:55 AM >To: [EMAIL PROTECTED] >Subject: RE: oledb and native drivers > > >I have done side by side comparisons with ODBC and OLEDB using SQL 7. >Contrary to common belief, the OLEDB actually ran anywhere from 5-20 ms >slower than with ODBC. I just completed work on a new version of our ad >serving software and I obviously wanted the fastest option available. I >was very surprised to find that OLEBD just didn't cut it. Again, this is >with SQL 7, so results may vary with different db's. >The best option that I have found is ODBC and Stored Procedures. If you >want a serious performance boost in db intensive apps, definitely convert >as much code as possible to stored procedures. > >IMHO, >Chris >-- >Original Message >From: "Robert Everland"<[EMAIL PROTECTED]> >Subject: RE: oledb and native drivers >Date: Thu, 3 Aug 2000 09:13:34 -0400 > >> In the testing I have found they have been just as fast as ODBC, >>plus add in the added headaches that certain commands your used to don't >>work in OLEDB, like the way dates are handled. It's really not a big deal >no >>article I have read has been able to give me hard numbers that prove OLEDB >>is faster so I will just stick with what works. >> >> >>Robert Everland III >>Web Developer >>Dixon Ticonderoga >> >> >>-Original Message- >>From: Rick Osborne [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, August 03, 2000 7:46 AM >>To: [EMAIL PROTECTED] >>Subject: RE: oledb and native drivers >> >> >>Native and OLEDB are *much* faster than ODBC. (For us it they were both >>literally an order of magnitude faster.) >> >>Someone may correct me on this, but as near as I can tell there really >isn't >>any difference between OLEDB and Native. That is, OLEDB is essentially >>"Native" for MS. >> >>If you are using SQLServer, I really can't think of a good reason why you >>wouldn't want to use OLEDB. >> >>-Rick >> >>-Original Message- >>From: Brian Mitter [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, August 03, 2000 6:21 AM >>To: [EMAIL PROTECTED] >>Subject: oledb and native drivers >> >> >>Hi All, &
RE: oledb and native drivers
I have done side by side comparisons with ODBC and OLEDB using SQL 7. Contrary to common belief, the OLEDB actually ran anywhere from 5-20 ms slower than with ODBC. I just completed work on a new version of our ad serving software and I obviously wanted the fastest option available. I was very surprised to find that OLEBD just didn't cut it. Again, this is with SQL 7, so results may vary with different db's. The best option that I have found is ODBC and Stored Procedures. If you want a serious performance boost in db intensive apps, definitely convert as much code as possible to stored procedures. IMHO, Chris -- Original Message From: "Robert Everland"<[EMAIL PROTECTED]> Subject: RE: oledb and native drivers Date: Thu, 3 Aug 2000 09:13:34 -0400 > In the testing I have found they have been just as fast as ODBC, >plus add in the added headaches that certain commands your used to don't >work in OLEDB, like the way dates are handled. It's really not a big deal no >article I have read has been able to give me hard numbers that prove OLEDB >is faster so I will just stick with what works. > > >Robert Everland III >Web Developer >Dixon Ticonderoga > > >-Original Message- >From: Rick Osborne [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 7:46 AM >To: [EMAIL PROTECTED] >Subject: RE: oledb and native drivers > > >Native and OLEDB are *much* faster than ODBC. (For us it they were both >literally an order of magnitude faster.) > >Someone may correct me on this, but as near as I can tell there really isn't >any difference between OLEDB and Native. That is, OLEDB is essentially >"Native" for MS. > >If you are using SQLServer, I really can't think of a good reason why you >wouldn't want to use OLEDB. > >-Rick > >-Original Message- >From: Brian Mitter [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 03, 2000 6:21 AM >To: [EMAIL PROTECTED] >Subject: oledb and native drivers > > >Hi All, > >Can someone explain the difference between oledb and native drivers for >connecting to datasources? > >In the CF Administrator there seems to be native drivers for Sybase11, >Oracle73, Oracle80, Informix83 and DB2. Should there be one for MS SQL? In >the oledb section of the administrator there is sqloledb and microsoft jet. > >We are using CF Enterprise 4.01 and MS SQL 7.0 What is the best way to >connect to the datasources on the SQL server? Any url's for more reading >matter on oledb and native drivers? Ive tried the Allaire site but the >search is still down. > >Thanks in advance > Brian > > >--- - >-- >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] with 'unsubscribe' in >the body. > >--- - >-- >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] with 'unsubscribe' in >the body. >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re:Random Numbers and Banner Managers
You can add a random number to your query then order by that. Try this: SELECT BannerAdID, #RandRange(1,9)# AS "Rand" FROMBannerAds WHERE Active = 1 ORDER BY RAND -- Original Message From: "Duane Boudreau"<[EMAIL PROTECTED]> Subject: Random Numbers and Banner Managers Date: Sun, 23 Jul 2000 16:53:52 -0400 >Hi All, > >I'm working on a banner manager program and I seem to be having a problem >getting a true random number. It seems that some of the banners pop up more >frequently than others. Here is the code I am using. Is there something >better I could be using to generate a random number or is this as good as it >gets? > > > SELECT BannerAdID > FROMBannerAds > WHERE Active = 1 > >andRange( 1, ListLen(ValueList(q_banners.BannerAdID> > >TIA, >Duane Boudreau >CFExperts.Com > > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re:COOKIES: CFX_HTTP: sending with header
Cookie: Name=Value;Name=Value;Name=Value Make sure the cookie header is on it's own line. Chris -- Original Message From: "!jeff!"<[EMAIL PROTECTED]> Subject: COOKIES: CFX_HTTP: sending with header Date: Thu, 20 Jul 2000 18:24:52 -0700 >After becoming completely disillusioned with CFHTTP (see CFHTTP and >cookies), I've decided to use CFX_HTTP for my project. > >So in order to SEND a cookie with a CFX_HTTP request, I believe that I will >have to use a parameter called AddlHeaders. > >So the question: >what is the syntax for a cookie header? when there are multiple cookies? > >thanks. >!j! > >The mark of mediocrity is searching for the precedent. > >!jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI > BIGWORDS.com worker#2 >.r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300 > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re:OT: Kind of bcc-question and question of secure mail ?
Are you in control of the mail client (ie. is this a web-based mail client)? If so, you can easily send one message to the intended address and send a copy of the message to your client's address and encrypt the body of the copied message. Then set up a simple page that the client can use to cut and paste the encrypted message into along with a password (encryption key) so that he may read the message should he need to. Chris -- Original Message From: "cftalk"<[EMAIL PROTECTED]> Subject: OT: Kind of bcc-question and question of secure mail ? Date: Tue, 11 Jul 2000 20:43:58 +0200 >Hi List, I have a client who wants to do the following: > >1) Everytime he sends an e-mail out of a specific post-office-box, he wants >to get a copy of the mail in another post-office-box. The clou is the user >shouldn't see it. How can I do this ? > >2) He doesn't want that his provider is able to view the post-boxes >(Mail-Server-side data) on the Server either. How is that managable ? Using >secure Mail ? > > >Don't blame me on the clients reuirements. I just want to find out, if I can >help him. > >Any Ideas what to do ? Maybe there is even a CF-Solutions out to at least to >the first topic. > >Thanks > >Uwe > > > > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
Re:Know where I can find Chr(*) definitions?
Try here: http://www.gyldan.com/~cuspy/cuspy/escape.htm Chris -- Original Message From: "Ric Smith"<[EMAIL PROTECTED]> Subject: Know where I can find Chr(*) definitions? Date: Fri, 7 Jul 2000 11:13:31 -0400 >Anyone know of anywhere I can find the definition >for the Chr(*) stuff online? Only ones I know are >Chr(10) and Chr(13). > >Just curious, thanks. > >Ric Smith > > >--- --- >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] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- 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] with 'unsubscribe' in the body.
RE: Spaces
Replace(CompanyName, " ", "", "ALL")
Specify the space, then the null (""), then ALL.
Chris
--
Original Message
From: "Larry Juncker"<[EMAIL PROTECTED]>
Subject: RE: Spaces
Date: Fri, 7 Jul 2000 07:41:01 -0500
>Kevin;
>
>I believe that you have to type all inside your last pair of quotes in
order
>to replace ALL of the spaces.
>
>Your code should like this:
>
>#Replace(CompanyName, " ", "ALL")#
>
>Hope this helps
>
>H Larry Juncker
> L Senior Cold Fusion Programmer
> I Heartland Communications Group
> Internet Division
>
>-Original Message-
>From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, July 06, 2000 8:36 PM
>To: CF Talk (E-mail)
>Subject: Spaces
>
>
>I'm trying to strip blank spaces from inside a string but am having no
luck.
>I tried this but no joy.
>
>#Replace(CompanyName, " ", "")#
>
>Any clues please?
>
>
>Kevin Parker
>Service and Communication
>WorkCover Corporation
>
>[EMAIL PROTECTED]
>
>ph: +61 8 82332548
>fax: +61 8 82332000
>
>
>
>
>
>***
*
>This e-mail is intended for the use of the addressee only. It may contain
>information that is protected by legislated confidentiality and/or is
>legally privileged. If you are not the intended recipient you are
prohibited
>from disseminating, distributing or copying this e-mail. Any opinion
>expressed in this e-mail may not necessarily be that of the WorkCover
>Corporation of South Australia. Although precautions have been taken, the
>sender cannot warrant that this e-mail or any files transmitted with it are
>free of viruses or any other defect.
>If you have received this e-mail in error, please notify the sender
>immediately by return e-mail and destroy the original e-mail and any
copies.
>***
*
>---
-
>--
>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] with 'unsubscribe' in
>the body.
>
>
>---
---
>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] with 'unsubscribe' in
the body.
>
_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
--
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] with 'unsubscribe' in the body.
RE: [Another Way...]Checking for a record, and then deleting it
Another thing that might be causing you a problem is the CRLF after the AND in the if statement. Make sure the initial if statement is all one one line. IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)) > 0) DELETE FROM SystemQuote WHERE CFID = #CFID# -- Original Message From: "Frédéric LeMieux"<[EMAIL PROTECTED]> Subject: RE: [Another Way...]Checking for a record, and then deleting it Date: Fri, 23 Jun 2000 09:52:08 -0400 >hmmm I never saw that kind of SQL statement. So I tried, and it is not >working ! >The Oracle Database returns "Invalid SQL statement". > >Where did you see that king of statement ? Can you give me more information >on how to make this king of SQL working ? > > >-Original Message- >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] >Sent: Friday, June 23, 2000 9:48 AM >To: [EMAIL PROTECTED] >Subject: Re:[Another Way...]Checking for a record, and then deleting it > > >Or you could do it all via SQL: > > >IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND >CFTOKEN=#CFTOKEN#)) > 0) > DELETE FROM SystemQuote WHERE CFID = #CFID# > > >Chris >-- >Original Message >From: "Chris Terrebonne"<[EMAIL PROTECTED]> >Subject: Re:Checking for a record, and then deleting it >Date: Fri, 23 Jun 2000 08:43:08 -0500 > >>Just test for the RecordCount... >> >> >>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) >> >> >> >> >> DELETE FROM SystemQuote WHERE CFID = #CFID# >> >> >> >>-- >>Original Message >>From: "Chris Farrugia"<[EMAIL PROTECTED]> >>Subject: Checking for a record, and then deleting it >>Date: Thu, 22 Jun 2000 21:24:46 -0400 >> >>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX >>>(which is an array that I used CFWDDX on), and the date. It is for a >>system >>>configurator for new computer systems. When someone fills in the forms >for >>>what they want on their system, it puts it in a database, then they can >>>click a reconfigure button... that takes them back to the form they just >>>filled out so they can reconfigure their system. THen they hit the submit >>>button again and here I need to check if a record in the quotes table >>>already exists (meaning this is at least the second time they've >configured >>>a system), and if it exists, then that record needs to be deleted. Here >is >>>the code I've tried but it doesn't work: >>> >>> >>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) >>> >>> >>> >>> >>> >>> DELETE FROM SystemQuote WHERE CFID = #CFID# >>> >>> >>> >>> >>> >>>Does anybody know of a way of doing this? Thanks in advance. >>> >>>- - >- >>--- >>>Archives: http://www.eGroups.com/list/cf-talk >>>To Unsubscribe visit >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >>send a message to [EMAIL PROTECTED] with 'unsubscribe' in >>the body. >>> >> >>_ >>Free email with personality! Over 200 domains! >>http://www.MyOwnEmail.com >> >>-- - >--- >>Archives: http://www.eGroups.com/list/cf-talk >>To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >> > >_ >Free email with personality! Over 200 domains! >http://www.MyOwnEmail.com > >--- - >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [Another Way...]Checking for a record, and then deleting it
Never tried it on Oracle. It works great on MS SQL 7. Check the Oracle docs for the correct SQL format of the statement and it should work Chris -- Original Message From: "Frédéric LeMieux"<[EMAIL PROTECTED]> Subject: RE: [Another Way...]Checking for a record, and then deleting it Date: Fri, 23 Jun 2000 09:52:08 -0400 >hmmm I never saw that kind of SQL statement. So I tried, and it is not >working ! >The Oracle Database returns "Invalid SQL statement". > >Where did you see that king of statement ? Can you give me more information >on how to make this king of SQL working ? > > >-Original Message- >From: Chris Terrebonne [mailto:[EMAIL PROTECTED]] >Sent: Friday, June 23, 2000 9:48 AM >To: [EMAIL PROTECTED] >Subject: Re:[Another Way...]Checking for a record, and then deleting it > > >Or you could do it all via SQL: > > >IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND >CFTOKEN=#CFTOKEN#)) > 0) > DELETE FROM SystemQuote WHERE CFID = #CFID# > > >Chris >-- >Original Message >From: "Chris Terrebonne"<[EMAIL PROTECTED]> >Subject: Re:Checking for a record, and then deleting it >Date: Fri, 23 Jun 2000 08:43:08 -0500 > >>Just test for the RecordCount... >> >> >>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) >> >> >> >> >> DELETE FROM SystemQuote WHERE CFID = #CFID# >> >> >> >>-- >>Original Message >>From: "Chris Farrugia"<[EMAIL PROTECTED]> >>Subject: Checking for a record, and then deleting it >>Date: Thu, 22 Jun 2000 21:24:46 -0400 >> >>>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX >>>(which is an array that I used CFWDDX on), and the date. It is for a >>system >>>configurator for new computer systems. When someone fills in the forms >for >>>what they want on their system, it puts it in a database, then they can >>>click a reconfigure button... that takes them back to the form they just >>>filled out so they can reconfigure their system. THen they hit the submit >>>button again and here I need to check if a record in the quotes table >>>already exists (meaning this is at least the second time they've >configured >>>a system), and if it exists, then that record needs to be deleted. Here >is >>>the code I've tried but it doesn't work: >>> >>> >>>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) >>> >>> >>> >>> >>> >>> DELETE FROM SystemQuote WHERE CFID = #CFID# >>> >>> >>> >>> >>> >>>Does anybody know of a way of doing this? Thanks in advance. >>> >>>- - >- >>--- >>>Archives: http://www.eGroups.com/list/cf-talk >>>To Unsubscribe visit >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >>send a message to [EMAIL PROTECTED] with 'unsubscribe' in >>the body. >>> >> >>_ >>Free email with personality! Over 200 domains! >>http://www.MyOwnEmail.com >> >>-- - >--- >>Archives: http://www.eGroups.com/list/cf-talk >>To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >> > >_ >Free email with personality! Over 200 domains! >http://www.MyOwnEmail.com > >--- - >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:[Another Way...]Checking for a record, and then deleting it
Or you could do it all via SQL: IF ((Select COUNT(*) FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)) > 0) DELETE FROM SystemQuote WHERE CFID = #CFID# Chris -- Original Message From: "Chris Terrebonne"<[EMAIL PROTECTED]> Subject: Re:Checking for a record, and then deleting it Date: Fri, 23 Jun 2000 08:43:08 -0500 >Just test for the RecordCount... > > >Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) > > > > > DELETE FROM SystemQuote WHERE CFID = #CFID# > > > >-- >Original Message >From: "Chris Farrugia"<[EMAIL PROTECTED]> >Subject: Checking for a record, and then deleting it >Date: Thu, 22 Jun 2000 21:24:46 -0400 > >>I have a table in a database that contains the fields CFID, CFTOKEN, WDDX >>(which is an array that I used CFWDDX on), and the date. It is for a >system >>configurator for new computer systems. When someone fills in the forms for >>what they want on their system, it puts it in a database, then they can >>click a reconfigure button... that takes them back to the form they just >>filled out so they can reconfigure their system. THen they hit the submit >>button again and here I need to check if a record in the quotes table >>already exists (meaning this is at least the second time they've configured >>a system), and if it exists, then that record needs to be deleted. Here is >>the code I've tried but it doesn't work: >> >> >>Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) >> >> >> >> >> >> DELETE FROM SystemQuote WHERE CFID = #CFID# >> >> >> >> >> >>Does anybody know of a way of doing this? Thanks in advance. >> >>-- - >--- >>Archives: http://www.eGroups.com/list/cf-talk >>To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >> > >_ >Free email with personality! Over 200 domains! >http://www.MyOwnEmail.com > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:Checking for a record, and then deleting it
Just test for the RecordCount... Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) DELETE FROM SystemQuote WHERE CFID = #CFID# -- Original Message From: "Chris Farrugia"<[EMAIL PROTECTED]> Subject: Checking for a record, and then deleting it Date: Thu, 22 Jun 2000 21:24:46 -0400 >I have a table in a database that contains the fields CFID, CFTOKEN, WDDX >(which is an array that I used CFWDDX on), and the date. It is for a system >configurator for new computer systems. When someone fills in the forms for >what they want on their system, it puts it in a database, then they can >click a reconfigure button... that takes them back to the form they just >filled out so they can reconfigure their system. THen they hit the submit >button again and here I need to check if a record in the quotes table >already exists (meaning this is at least the second time they've configured >a system), and if it exists, then that record needs to be deleted. Here is >the code I've tried but it doesn't work: > > >Select * FROM SystemQuote WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#) > > > > > > DELETE FROM SystemQuote WHERE CFID = #CFID# > > > > > >Does anybody know of a way of doing this? Thanks in advance. > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFX API Question...
How does the CFX API handle simutaneous requests? Does CF spawn a new instance of the attached CFX DLL for each simultaneous request, or does it assume that the CFX DLL can handle simultaneous requests itself and direct requests to the existing instance? If it is the later, then is there a way within the API to determine when a new request is recieved? Thanks, Chris _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: LOOP'ing challenge
That will make CF parse the list twice. You definitly don't want to do that if the file is large. Try this: I haven't tested the code, but you get the idea. Hope that helps, Chris -- Original Message From: "Bud"<[EMAIL PROTECTED]> Subject: Re: LOOP'ing challenge Date: Tue, 23 May 2000 16:36:49 -0400 >On 5/23/00, [EMAIL PROTECTED] penned: >>I'm stuck on something that might be really simple to someone. >> >>I have these large flat files that are carriage return delimited that >>contain the same data over and over again. I'm trying to parse out >>this data for display and later for database insertion. >> >>I've figured out how to pull out the email address information but >>I need to pullI out the name information too. Here's what I have so >>far and the format of the flat file. >> >>***BEGIN**FLAT**FILE** >>Email: [EMAIL PROTECTED] >>Name: firstname lastname >>Email: [EMAIL PROTECTED] >>Name: firstname lastname >>Email: [EMAIL PROTECTED] >>Name: firstname lastname > >Since the first word of each 2 record recordset you're trying to >capture is Email, why don't you do it like this: > >VARIABLE="text"> > > > > > >That should effectively make the text variable look like this: > >Email: [EMAIL PROTECTED] >Name: firstname lastname|Email: [EMAIL PROTECTED] >Name: firstname lastname|Email: [EMAIL PROTECTED] >Name: firstname lastname > >Than you can do a loop on the pipe delimiter and nest a loop inside >on the chr(13) delimiter . That should give you a good start. > > >Bud Schneehagen - Tropical Web Creations > >_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >ColdFusion Solutions / eCommerce Development >[EMAIL PROTECTED] >http://www.twcreations.com/ >954.721.3452 >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: banner ad weighting....
Your right. If a % of impressions is all that is required, then your method would be perfect. Although when a site reaches the level in which larger companies and/or media buyers are purchasing impressions, the "% of impressions with no guarantee" is not going to fly. Don't get me wrong, your method is very good for what you wish to accomplish, but it is not scalable for a site that puts a heavy burden on advertising revenue. Chris -- Original Message From: "Al Musella, DPM"<[EMAIL PROTECTED]> Subject: RE: banner ad weighting Date: Fri, 14 Apr 2000 10:16:19 -0400 >You didn't read the original specs > >They requested a banner ad rotation system that allocates the ads on a >fixed ratio, not by number of monthly impressions. I copied the specs below. >I sell banner ads on one of my sites also with this method - a fixed >monthly fee for a % of impressions with no guarantee of number of >impressions. > >Al Musella >World Wide Websites > >Specs: >=== >The way the banner displays are going to work is this >All Fusioneers.com partners are entitled to a free banner ad on our >site. People who pay a monthly fee will obviously be given a far greater >weighting factor than the freebies. > >So, our plan was to do something like the following: > >All freebie ads combined would account for 1% of the total weighting factor. > >We would then sell off weights in blocks of 10%, 20% and 30% of >impressions until the maximum of a 100% has been reached. The unsold >weight blocks would display a "Your Ad Here" ad. > >So, in other words, when we display the ads, they will be called at >random, but I want the weights to affect their odds of being displayed. >== > >At 08:08 AM 4/14/2000 -0500, you wrote: >>That is a good idea. The only problem is that media buyers and/or >>companies buy blocks of a set number of impressions. Your proposed method >>does not allow for traffic fluctuation and site availability fluctuation. >>Each ad campaign should be based on a set number of impressions then >>progmatically compared against the average impressions for the site. This >>can easily be accomplished by using a nightly task that calculates the >>average site impressions for the last 5-7 days then re-calculates all >>campaigns based on the new average. This ensures that if a buyer purchases >>100,000 impressions for 30 days, that is exactly what they get. >> >>Chris Terrebonne >>-- >>Original Message >>From: "Al Musella, DPM"<[EMAIL PROTECTED]> >>Subject: RE: banner ad weighting >>Date: Thu, 13 Apr 2000 15:40:27 -0400 >> >> >There may be a much simpler way: >> > >> >For each ad, just have 1 field that specifies what % that ad should have. >> >Whenever you add / edit an ad (maybe use a trigger), have it then fill in >> >(or update) 2 more fields, call it N1 and N2, with the numbers from 0 to >> >100 which represent that fraction they should get.. for example: >> > >> > >> >Ad titlePercent N1 N2 >> >Ad1 20 0 20 >> >Ad2 50 20 70 >> >ad3 30 70 100 >> > >> >Now just generate a random number , R, from 0 to 100. >> > Look for the ad where R is between N1 and N2 >> > I did something like that, and the ads come out remarkably close to the >> >predicted frequency! >> > >> >Al Musella >> >World Wide Websites >> > >> >--- >>--- >> >Archives: http://www.eGroups.com/list/cf-talk >> >To Unsubscribe visit >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >>send a message to [EMAIL PROTECTED] with 'unsubscribe' in >>the body. >> > >> >>_ >>Free email with personality! Over 200 domains! >>http://www.MyOwnEmail.com >> >>-- >>Archives: http://www.eGroups.com/list/cf-talk >>To Unsubscribe visit >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >>send a message to [EMAIL PROTECTED] with 'unsubscribe' in >>the body. > > >--
RE: banner ad weighting....
That is a good idea. The only problem is that media buyers and/or companies buy blocks of a set number of impressions. Your proposed method does not allow for traffic fluctuation and site availability fluctuation. Each ad campaign should be based on a set number of impressions then progmatically compared against the average impressions for the site. This can easily be accomplished by using a nightly task that calculates the average site impressions for the last 5-7 days then re-calculates all campaigns based on the new average. This ensures that if a buyer purchases 100,000 impressions for 30 days, that is exactly what they get. Chris Terrebonne -- Original Message From: "Al Musella, DPM"<[EMAIL PROTECTED]> Subject: RE: banner ad weighting Date: Thu, 13 Apr 2000 15:40:27 -0400 >There may be a much simpler way: > >For each ad, just have 1 field that specifies what % that ad should have. >Whenever you add / edit an ad (maybe use a trigger), have it then fill in >(or update) 2 more fields, call it N1 and N2, with the numbers from 0 to >100 which represent that fraction they should get.. for example: > > >Ad titlePercent N1 N2 >Ad1 20 0 20 >Ad2 50 20 70 >ad3 30 70 100 > >Now just generate a random number , R, from 0 to 100. > Look for the ad where R is between N1 and N2 > I did something like that, and the ads come out remarkably close to the >predicted frequency! > >Al Musella >World Wide Websites > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: banner ad weighting....
OK, here's how to do the weighing (at least how I did it): First off, you create a DB table that contains the sites/pages that will contain the banner campaigns. For you, you should just create one entry in the table for your primary site. This row contains the columns ID (auto-int), SiteName (varchar), Impressions(int). The impressions field is the important one because it will be the basis of the weighting. You can either set this to a static number based on what you believe to be the average daily impressions of your site, or you could collect the impression data in a seperate table and then update the site table with an average. The second table is the Campaign table. This will contain all of the campaigns for your all sites. The most basic columns should be ID (auto-int), CampaignName (varchar), StartDate (date-time), EndDate (date-time), Impressions (int), IsActive (bit), IsDefault (bit), Weight (int). The important ones here are the IsDefault, StartDate, EndDate and Impressions. Every campaign should have these. Most ad campaigns run for 30 days, but that really depends on you. If a ad customer buys 100,000 impressions for 30 days, you enter the appropriate start and end dates along with the 100,000 impressions. The IsDefault bit is only set for the campaign that will take any remaining impressions (such as your "Your add here" example). Upon inserting or updating the table, you can either have CF or a trigger peform the weighting. The basic weighting will use 100% as the maxium weight. The weighting will be calculated by dividing the campaign's total impressions by the total days for the run. This will give you an average daily impression count. Then divide that number with the average daily impressions for the site, and that is your weighting. Add that to the weighting field. Each time a new campaign is added the "default" campaigns weight should be recalulated to comprise the remaining impressions or weight for the site. Now, when a user requests a banner, the winner is determined by first creating a random number between 1 and 100. Then assign a block of numbers to each campaign based on it's weight (example: if you have 4 campaigns the first will get numbers 1-25, the next 26-50 and so on). Then you simply loop through the campaign query and determine the winner by the random number and the weight. And that's it. Hope that helps. Chris Terrebonne -- Original Message From: "Bob Hendren"<[EMAIL PROTECTED]> Subject: RE: banner ad weighting Date: Wed, 12 Apr 2000 22:49:51 -0400 >I thought about this a couple of weeks ago as a two-stage issue. First, you >could setup your weighting percentages and any leftover unused spaces. Then >you could create a memory structure to hold the next n number of banners >(100, 1000, 10K) and randomly populate that according to the weighting >percentages. This sounded good to me because you're dividing the load up - >the serving of the banners is accomplished by walking through the memory >array that is created and the randomizing of the banners is done >periodically when that memory array runs out. This was all in my head - not >actually put in practice yet! Just opinion so far. Let me know what you >think. > >- >Bob Hendren >BrainKeepers >E-Commerce - Internetworking - Information Systems >404-375-2258 >[EMAIL PROTECTED] > >-Original Message- >From: Tom Forbes [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, April 12, 2000 10:32 PM >To: [EMAIL PROTECTED] >Subject: Re: banner ad weighting > > >How about an array or look-up table. I did this successfully with a Monte >Carlo simulation I wrote to address queing theory. Was that a dry project. > >Tom > > > > >At 10:01 PM 4/12/00, you wrote: >>Hello All, >> >>I plan to offer banner ads on our Fusioneers.com web site ASAP. I don't >>want to use any of the canned scripts from the developer's exchange for >>various reasons that I don't want to dwell on here. >> >>The way the banner displays are going to work is this >> >>All Fusioneers.com partners are entitled to a free banner ad on our >>site. People who pay a monthly fee will obviously be given a far greater >>weighting factor than the freebies. >> >>So, our plan was to do something like the following: >> >>All freebie ads combined would account for 1% of the total weighting >factor. >> >>We would then sell off weights in blocks of 10%, 20% and 30% of >>impressions until the maximum of a 100% has been reached. The unsold >>weight blocks would display a "Your Ad Here" ad. >> >>S
automated response
-- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
