Hello Guys,
I've just started work on a large scale rebuild of my core business
application, and to aid me the gruelling task I'm toying with implementing
MG, ColdSpring and one of the ORM's. I've done some small work with these in
the past but used Reactor. Now, I'm sure I've read somewhere
it can support them.
HTH
N
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 09:06
To: CF-Talk
Subject: Choosing an ORM
Hello Guys,
I've just started work on a large scale rebuild of my core business
application, and to aid me
Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 09:47
To: CF-Talk
Subject: RE: Choosing an ORM
Thanks Neil and Mark,
I remember the whole 'active' records and really liked that concept, but to
be honest I've gotten myself tied quite nicely into using
and are wasted resources unless you have a dedicated instance
doing all that legwork etc.
You want to encrypt all of your data in and out of your app?
Location: London.
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 10:26
To: CF
it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com
-Original Message-
From: Robert Rawlins - Think Blue
To: CF-Talk
Sent: Mon Jun 04 10
Yeah you can't cache in anything other than CF8,
Rob
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 13:48
To: CF-Talk
Subject: Re: Choosing an ORM
On Monday 04 Jun 2007, Robertson-Ravo, Neil (RX) wrote:
In fact, re-reading the docs re: SP's I am
Have you got any more information? I use mine with no problems at all, is
this the version that comes bundled with cf? Or a privately owned copy? Are
you on windows? Mac? Linux? What error messages do you get?
Thanks,
Rob
-Original Message-
From: Leitch, Oblio [mailto:[EMAIL PROTECTED]
E-mail: Â Â Â Â Â Â Â [EMAIL PROTECTED]
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 04, 2007 4:06 AM
To: CF-Talk
Subject: Choosing an ORM
Hello Guys,
I've just started work on a large scale rebuild of my core business
PROTECTED]
Sent: Monday, June 04, 2007 10:08 AM
To: CF-Talk
Subject: RE: Choosing an ORM
Certainly does look nifty..be good to see what kind of performance his it
has though...
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 14:40
To: CF-Talk
and Information Technology
E-mail: [EMAIL PROTECTED]
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 04, 2007 4:06 AM
To: CF-Talk
Subject: Choosing an ORM
Hello Guys,
I've just started work on a large scale rebuild of my
P.S. nice articles Ben, as always mate.
Rob
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 16:59
To: CF-Talk
Subject: NEWS: Great 3 part series on CF8's CFTHREAD tag by Ben Nadel
Definitely worth a read:
Part 1:
:-o
I'd forgotten that it now supports threading, sweet Jesus, we're all doomed!
DOOMED! ;-)
-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: 04 June 2007 16:59
To: CF-Talk
Subject: NEWS: Great 3 part series on CF8's CFTHREAD
Hello Guys,
I'm having trouble working with encrypt() and decrypt(). I've generated my
own key and I'm trying to use AES encryption on a simple 'hello world'
string, see my code below.
cfset myKey = ToBase64(BinaryDecode(12345678901234567890123456789012,
Hex)) /
cfset myString = Hello
Well, My suggestion would be to put the weight of the task on the DB Engine
if possible rather than CF, it'll be much more efficient.
I'm a SQL Server guy and don't know MySQL very well, but from memory they
have a REPLACE function, which determines if the record needs to updated or
inserted, it
are not decrypting an encrypted string...
cfset decrypted = Decrypt(myString, myKey, AES) /
would need to be
cfset decrypted = Decrypt(encrypted, myKey, AES) /
or I may just be missing something else at first glance also.
J.J.
On 6/3/07, Robert Rawlins - Think Blue
[EMAIL
Hello Guys,
I'm at the point where I really need to start thinking about the encryption
of data for my app. We're running MX7 and SQL Server 2005 and from what I've
read CF seems to have some fairly decent tools out of the box and ready to
use. I've also heard people talking about different
Hello Guys,
I've done some work in the past with digital contact and calendar cards,
such as vCard/Cal and iCard/Cal and I'm now looking to expand on this a
little bit.
The first thing I'm after is some ideas on the best way to implement a
database model for dealing with them, has anyone
It's true, I buy '.NET' magazine every month and all they talk about is PHP.
Journalism is a funny beast, God only know how many articles I've read
stating that PS3 is superior to the XBOX 360, we all know that just isn't
the case.
Best bet is to take it all with a great big mouth full of salt.
In all fairness,
All the best programmers I've ever met have been self educated or hobbyists
turned professional.
I've never considered academic studies in any fast moving industry a
particularly good way to spend time, the curriculum is so out of date that
the skills you learn have no relevance
joining table between them (user_entitlement or
similar). This way only a true (1) is indicated in the DB and you can
assume false for everything else (inlcuding when initialising the
struct in CF).
On 5/24/07, Robert Rawlins - Think Blue wrote:
The structs method work nicely from a ColdFusion
the difference.
Hope that helps.
Brian
On 5/23/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:
Guys,
I'm hoping to answer a bit of an old age question that I've been toiling
with for time with reference to OO methods and how deeply they should be
applied. I'm going to take a reasonably
This Load Testing is very intriguing stuff, something I've not considered
doing until this topic came up.
How does this stuff work with user authentication? The large majority of my
application (all except one lonely cfm) are behind my authentication system,
is this passler software (or any of
Far?
On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote:
should this be an array of structs? Or can you perhaps do an array of
product.cfc objects? Hehe, it's like the old proverb which I believe goes
The latter.
In an ideal world, Cart needs to know nothing about how Product works
Hello Chaps,
I'm currently working on an overhaul for my security/authentication model
and finally reached the core element, which is the granular permissions.
I've seen several different solutions for achieving this kind of thing and
thought I'd try and see what everyone here does for their
]
Sent: 24 May 2007 09:56
To: CF-Talk
Subject: Re: Load Testing
On Thursday 24 May 2007, Robert Rawlins - Think Blue wrote:
How does this stuff work with user authentication? The large majority of
my
application (all except one lonely cfm) are behind my authentication
system, is this passler
and an m:n joining table between them (user_entitlement or
similar). This way only a true (1) is indicated in the DB and you can
assume false for everything else (inlcuding when initialising the
struct in CF).
On 5/24/07, Robert Rawlins - Think Blue wrote:
The structs method work nicely from a ColdFusion
Yep I'll back Niel on this one,
I pass XML as a string through web services all the time and it works like an
absolute charm. I talk with all kinds of other apps from JAVA through to Python
and C.
Rob
-Original Message-
From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]
Sent:
Guys,
I'm hoping to answer a bit of an old age question that I've been toiling
with for time with reference to OO methods and how deeply they should be
applied. I'm going to take a reasonably simple examples and try and get your
thoughts on the best way to achieve this. For my example I'm
Just out of interest Will,
How many domains do you have pointing at the site? Is it possible that you have
several and they've picked it up as duplicate content as you werenât
returning a 403 on the domains?
Rob
-Original Message-
From: Dave l [mailto:[EMAIL PROTECTED]
Sent: 23 May
server to
manage these - they are done as standard forwarding. No idea as to how to
set up a 403 on these domains so I best check the Plesk docs.
Cheers
Will
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 23 May 2007 10:13
To: CF-Talk
Subject: RE
Ok Great Tom,
Thanks for your reassurance on this one.
Rob
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: 23 May 2007 10:54
To: CF-Talk
Subject: Re: An OO Too Far?
On Wednesday 23 May 2007, Robert Rawlins - Think Blue wrote:
So if I were to write this in an OO
the
permanent redirection for this resource box.
I'm yet to see if this solves the problem, but I have asked Google to re-spider
the site so we'll see!
Cheers
Will
-Original Message-
From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED]
Sent: 23 May 2007 10:32
To: CF-Talk
Hello Guys,
I'm looking for some advice on whether I should be using a 2 dimensional
array or a array of structs for this kind of thing. I'm looking to store a
list of users in an array, but also some other information on them, similar
to a virtual table I guess, like this.
Name
Guys,
I've not worked with 2 dimensional arrays in a while and I'm stumbling with
what's seems like a simple issue of add a new element to the end of the
array. The current method I'm using is this:
cfargument name=User_ID type=string required=true
hint=The user unique id for
In addition to Neils advice,
Ensure that both your cfcomponent and cffunction tags have
output=false set in them aswell. And you may want to look into the
cfprocessingdirective tag and the 'supresswhitespace' attribute on that.
There is also a setting in the cfadmin panel than can be turned on
Chaps,
I'm trying to parse a text file into my database but struggling a bit as the
text file is large and not particularly well formatted for this kind of
thing, unfortunately it's the only version I have access to :-D (Oh the
joy).
The text file can be found here
Subject: Re: Parse Complex Text File
On Thursday 17 May 2007, Robert Rawlins - Think Blue wrote:
It might be worth nothing this database is updated daily by the standards
commission, so I'll be doing a fresh import every couple of days at least.
I wouldn't consider a 5 minute parse time every few
Can we see you exact query code?
There are a few things you can do to optimize, firstly don't use *, list the
columns with a comma to separate them, it'll speed the query up. Next on
your output scope your column to the query like #get_info.Code# and
#get_info.descr#.
That'll help for a start
Thanks for all your help on this one guys,
As with Judah this is the part of ColdFusion I'm yet to really study, but it
all sounds pretty interesting. I'm sure that J2EE sessions will support my
applications, I'm not using any particularly advanced session functions,
it's just a place to store my
Hello Guys,
Over the past few months I've been working on security best practices for
myself whilst constructing an application, and I've managed to get my head
around a few of the concepts like plugging XXS and SQL Injection attacks but
session hijacking is still something I'm yet to take
I've not got an example of how a session might be hijacked specifically in
CF, but I've seen examples from PHP and ASP, where the client has their
cookie data and session ID stolen using a packet sniffer, this session data
is then applied to the attackers browser and then as far as the server is
Ah that's good to know, I'm running SSL. I'm guessing the J2EE sessions are
pretty tidy them. I'm running ColdFusion in its standalone mode, does that
still use J2EE sessions?
Are there any specific application settings I should be using in my
application.cfc to help keep this all buttoned
into the memory vars section of the administrator and check
the box for Use J2EE session variables.
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 14, 2007 11:09 AM
To: CF-Talk
Subject: RE: Session Security
Ah that's good to know, I'm running
Hey Pete,
Look under the 'flash forms' section here http://www.asfusion.com/examples/
they have a load of stuff on 'binding' they do a couple of examples using
check boxes which might suite your application more, at the moment they only
bind to another check box, so you check one, and another
Would someone mind giving me a quick 'synopsis' or what replication is all
about? Presumably this is so you can run two identical setups with a network
load balancer in the middle?
I'm sure that blind guess is complete wrong though :-D just trying to learn
something new.
Thanks guys,
Rob
I had this same error on my Ultimate system, but Eclipse seems to run
perfectly anyway.
Rob
-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED]
Sent: 11 May 2007 15:33
To: CF-Talk
Subject: Re: Eclipse on Vista
On Friday 11 May 2007, [EMAIL PROTECTED] wrote:
When I was
Hey Ben,
Just having a quick read through your article, great work. I'm interested by
the opening section though that discusses the problems of app.cfc and it
blocking web services. I publish several web services from my application which
is running a standard app.cfc and they are consumed
BY could be reducing the total
number of hours down to 11. You may need to do it in a nested query or
create a view for your first query (that sums and counts), then LEFT
OUTER JOIN that view to the Hours table.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL
Guys,
I've got a weird drawing issue with my chcharts, for some sets of data it
seems to screw up where the data points should be, I've taken a screen
capture to show you what I mean.
http://80.244.184.135/chart.png
As you can see, it plots the lines as it should do, but seems to
Great stuff Rick,
I look forward to reading it, Once it's up for all to see be sure to post a
link.
Rob
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 08 May 2007 13:12
To: CF-Talk
Subject: Re: Lack of CF understanding: Info Week
I also wrote to the author of the
: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 2:33 AM
To: CF-Talk
Subject: RE: Table Data
Morning Mike,
I think part of the problem was that the group by was cutting it down to
11 hours, so I worked with an SQL guy on creating a sub query, it took a
few revisions
Sweeet.
Duuude, what does mine say?
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 08 May 2007 19:52
To: CF-Talk
Subject: RE: Add Together Values of Dyanamic Fields
Sweeet.
-Original Message-
From: Joel Watson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May
gaps, however, it won't prevent any
extra records. For example, if there were two articles posted between
9-10, then you would get 25 records.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 9:28 AM
To: CF-Talk
Subject: RE
.
It's possible the OUTER JOIN isn't working as I thought it would, but I
don't see why not. Removing the WHERE clause will help find that
problem as well.
Good luck!
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 6:52 AM
To: CF
problem doing a file upload via a CFC.
One thing that's helped me is to wrap the file upload action in a try/catch
block. If it fails, return a message with the error details. If it
succeeds, return an upload successful message.
-- Josh
- Original Message -
From: Robert Rawlins - Think
Hello Guys,
I've just bought myself a licence for the Alagad image cfc and have been
VERY impressed with it so far, damn quick that's for sure. I'm going to be
working mainly with GIF files which are not natively supported by java so
the component can't give me that function.
However, I've
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
Hello Guys,
I've got a file upload facility that can receive a few different types of
files, from images to vcards and vcals and I want to treat them all slightly
differently, how can I extract the file name and the file extension from the
form field that's been submitted? I can then look at
, upload the file to a temp directory, Use CFFILE.SERVERFILE to
obtain the name then parse it to get the name and extension if you need it
in 2 parts
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 5:28 AM
To: CF-Talk
Subject: File
Hey Guys,
Something crossed my mind this morning and I thought I'd run it past you,
see what your thoughts on it were. In my application I have allot of queries
that pull data dependant on the user that is currently signed in using the
user_id which sits in their session. Now for the moment I
/htmldocs/wwhelp/wwhimpl/common/ht
ml/wwhelp.htm?context=ColdFusion_Documentationfile=0253.htm
Rick
On 5/4/07, Adkins, Randy [EMAIL PROTECTED] wrote:
I usually to a ListLast(cffile.serverfile,.)
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday
What's in that query?
Rob
-Original Message-
From: heath stein [mailto:[EMAIL PROTECTED]
Sent: 04 May 2007 13:52
To: CF-Talk
Subject: ODBC Server Error
We are running into a problem with our server, that is running Coldfusion
MX7 . Its seems every 12 to 24 hours the server stops
the object to see if there is a method for compresion
ratio?
On 5/4/07, Robert Rawlins - Think Blue [EMAIL PROTECTED]
wrote:
Hello Guys,
I've just bought myself a licence for the Alagad image cfc and have
been VERY impressed with it so far, damn quick that's for sure. I'm
going to be working
: RE: Alagad GIF
Oh...that's nice. I didn't realize you could upgrade the file types for
Alagad. Nice.
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 8:09 AM
To: CF-Talk
Subject: RE: Alagad GIF
Sure thing Andy,
I'm now
Morning Rey,
I bought a copy of the Alagad component this morning and have been very
impressed with it. There are a couple of open source ones available on the
market, I used one last year (but forget the name) and it wasn't too bad,
but Alagad defiantly have it sorted, for the sake of $70 it's
I'm trying to replace the .jpg file extension on in a string with .gif and
using the following regex.
cfset LOCAL.New = 'D:\MediaStore\' REReplace(ARGUMENTS.File, '.jpg',
'.gif', 'ALL') /
ARGUMENTS.File is a string that looks like 'myfile.jpg'
Am I missing something here?
Thanks,
many empty rows remain. The
formula would be 24 - query.recordCount. Then, a simple CFLOOP to
display the remaining, empty rows.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 2:33 AM
To: CF-Talk
Subject: Table Data
, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
I'm trying to replace the .jpg file extension on in a string with .gif and
using the following regex.
cfset LOCAL.New = 'D:\MediaStore\' REReplace(ARGUMENTS.File, '.jpg',
'.gif', 'ALL') /
ARGUMENTS.File is a string that looks like
make a mapping you can copy everything from
/CFIDE/scripts/ into the same location in your website.
On 5/2/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
Hey James,
Thanks for getting back to me. I'm not sure quite what you mean by the
mapping question, I'm a bit naive when it comes
Hello Guys,
I'm looking for a few ideas from you on the best way to handle statistical
data. I have allot of statistical information on my current application and
when presented I perform general mathematical equations on it, such as
calculating totals, averages, rations and percentages.
Hello Guys,
Is it possible to loop through a query object and add additional columns
containing calculated data? I'm sure I've seen a function like queryNew() or
something like that. I've got a query returned from the database, I'm just
looking to append a few extra columns.
Thanks,
:-O
*Slaps Rick for speaking ill of the Microsoft Corporation ;-)
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 03 May 2007 14:47
To: CF-Talk
Subject: OT Rant: SQL Server
I used the following query to retrieve the email addresses for a
mailing, and didn't notice
I had similar issues yesterday with flash charts.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:51457
Give the last solution ago with mapping a CFIDE folder.
Rob
-Original Message-
From: Pete [mailto:[EMAIL PROTECTED]
Sent: 03 May 2007 15:05
To: CF-Talk
Subject:
Hello Guys,
I've not really worked with file uploads very much, I've done a couple of
small ones using standard procedural methods in CFM pages, but I'm quite
keen for my next venture to move this into a CFC along with all my other
'proper' code.
Has anyone had any experience with this,
/2/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
Thanks for the suggestion carl,
I'll have a look around, I've got a couple of cfdumps on the screen which
obviously run JavaScript for all their bend-ability. I'll try ripping them
out and see if it'll make any difference, but I would
-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 02 May 2007 11:19
To: CF-Talk
Subject: Re: Flash Chart
Ah, this probably means that the scripts needed to make IE bahave
can't be found. What do you have for a webser mapping to /CFIDE?
On 5/2/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED
Yep I'll second Andrew on this one,
For a short hand, many people just create a var'd structure in the top of
each function and then reference everything else into the structure,
something like this.
cffunction
cfset var LOCAL = structNew() /
cfset LOCAL.this = somthing /
Hello Guys,
I'd like to get your thoughts on the differences between cfscript and
standard cfml tag based code. I've worked using both methods for some time
now and feel equally comfortable with them, so this isn't really a question
of preference, but the benefits of performance and features
Hello Guys,
I have a bunch of records of log data, all with a datetime stamp on it, and
I'm looking to have SQL Server return them grouped into hours. I've done
this before using MySQL I think, using the Hour() function in the query but
it would seem that SQL Server doesn't support such a
sure
you're grouping by more than just the hour. Otherwise, in your grouped
output, you would have all of that hour for as many different month/day/year
combos as are in your database (unless, that is, you're passing in a single
date)
Pete
On 5/1/07, Robert Rawlins - Think Blue [EMAIL PROTECTED
Don't Worry,
Onto something now with that date part stuff.
I'll let you know how I get on.
Rob
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: 01 May 2007 13:48
To: CF-Talk
Subject: RE: Group By Hours
Thanks for the suggestion Pete,
I'm sure
Ok,
So I now have this grouping as I want it too, using that date part function,
I just need a little help with the counting. Look below for my current query
and the results returned.
!--- Query to Obtain Records ---
cfquery name=LOCAL.qGetAllDateRangeForUnitByDay datasource=
SELECT
Thanks for the input on this stuff guys,
I think I can agree with you Chris, that was always my line of thought that
cfscript is nearer to the runtime code and will need less parsing and
compiling than the standard tag based code, I'd like to see some charted
data on this stuff, Maybe I'll
as you said, except the syntax is:
SUM(CASE WHEN logclass_id = 1 THEN 1 ELSE 0 END) as sent
On 5/1/07, Robert Rawlins - Think Blue wrote:
Ok,
COUNT(WHERE LogClass_ID = 1) AS Sent
COUNT(WHERE LogClass_ID = 2) AS Failed
COUNT(WHERE LogClass_ID = 3) AS Postponed
Hello Guys,
I'm having problems with a flash based CFCHART. When the chart is set to jpg
or png it renders fine but when set to flash it doesn't appear in the
browser and I get a 'page done but with errors' on the bottom of my browser.
I have flash charts on other apps on the same server and
HTH,
Jon
On May 1, 2007, at 10:30 AM, Robert Rawlins - Think Blue wrote:
Hello Guys,
I'm having problems with a flash based CFCHART. When the chart is
set to jpg
or png it renders fine but when set to flash it doesn't appear in the
browser and I get a 'page done but with errors
.
color,font, etc) to the chart? If so, if you create the chart
without any design/font parameters does that make a difference? I
know there are a limited number of colors that cfchart accepts as
well as limitations on fonts.
HTH,
Jon
On May 1, 2007, at 11:03 AM, Robert Rawlins - Think
Thanks for the suggestion carl,
I'll have a look around, I've got a couple of cfdumps on the screen which
obviously run JavaScript for all their bend-ability. I'll try ripping them
out and see if it'll make any difference, but I would have thought they
should play nicely together.
Thanks,
Rob
Hello Guys,
I'm looking to work on a solution for working with re-occurring events,
similar to a calendar application I guess. I have a current solution in one
of my applications but it REALLY doesn't cut the mustard as it relies on
large numbers of database entries, so if you create an event
'with'. If this statement is a common
table expression or an xmlnamespaces clause, the previous statement must be
terminated with a semicolon.
Which would suggest it doesn't like me using a variable for the file path.
Any ideas?
Thanks,
Rob
-Original Message-
From: Robert Rawlins - Think
Hello Chaps,
Looking for a little help with writing a stored procedure, It's nothing
OVERLY complex, but it's a little beyond me at the moment. Basically the
proc will perform a bulk insert from a text file which is simple enough, but
I need it to split that up into two tables. Here is a quick
PROTECTED]
Sent: 23 April 2007 09:34
To: CF-Talk
Subject: Re: Stored Proc Help
Robert Rawlins - Think Blue wrote:
GF:34:00:3F:FD, 6, 1, 2007-01-01 13:00:00, 1
GF:34:00:3F:FD, 6, 2, 2007-01-01 13:01:00, 1
GF:34:00:3F:FD, 6, 1, 2007-01-01 13:04:00, 1
GF:34:00:3F:FD, 6, 4, 2007-01-01 13:08:00, 1
'.
Any ideas?
Thanks,
Rob
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 23 April 2007 09:34
To: CF-Talk
Subject: Re: Stored Proc Help
Robert Rawlins - Think Blue wrote:
GF:34:00:3F:FD, 6, 1, 2007-01-01 13:00:00, 1
GF:34:00:3F:FD, 6, 2, 2007-01-01 13:01:00
Hey Alley,
Try dumping the query cfdump var=#qPageHitsReport # / to make sure that
CF7 isnt doing anything funny with your query like renaming the columns.
Also make sure that you scope that variable so do #qPageHitsReport.PGE_ID#
inside the url, see if that helps.
Let me know,
Rob
Following on from my query this morning about the stored proc, I've started
dabbling with the query in CF to start with, just as it feels more familiar.
I'm struggling to get the following piece of code working though:
cfquery name=qCommitLogs datasource=MyDSN
BULK
-Talk
Subject: Re: Bulk Insert
The text file needs to be on the SQL server
Is CF and MS-SQL on the same box?
If not, you will need to get the text file onto the SQL Server.
On 4/23/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:
Following on from my query this morning about the stored
errors.
Greetings / Grüsse
Gert Franz
Customer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/
Robert Rawlins - Think
through before?
maybe a permissions thing
=http://msdn2.microsoft.com/en-us/library/ms188365.aspx
Requires INSERT and ADMINISTER BULK OPERATIONS permissions
Wrap a cftry around the cfquery and dump cfcatch
On 4/23/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:
Thanks for the suggestions
in the where clause
eg WHERE DeviceStaging.MacAddress NOT IN (
SELECT ma2.MacAddress
FROM MacAddress ma2)
On 4/23/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED]
wrote:
Thanks AJ, That's all sorted now. :-D
Next part of my query is now causing problems (again with no CF error,
Doh!)
I'm
Why do I get the feeling that was a subtle hint aimed at me ;-)
Rawlins
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: 23 April 2007 16:49
To: CF-Talk
Subject: (Admin) Please use proper lists
Just as a reminder: There are more lists on House of Fusion than
201 - 300 of 422 matches
Mail list logo