tracking and was a random cookie used only to
help the load balancer keep server affinity. I was rather annoyed with that
prognosis seeing as how any competent programmer worth his salt could look
at my response headers and see the jsessionid in there, but a professional
PCI compliance scanning
On 2/13/10, Matthew Smith wrote:
I am generating static html for item pages. I am trying to remove
everything but the words and replace the spaces with -.
The inner replace works properly, the outer one is removing the hyphens.
So do it the other way around: first replace everything but
I am generating static html for item pages. I am trying to remove everything
but the words and replace the spaces with -.
The inner replace works properly, the outer one is removing the hyphens.
cfset request.generation.filename =
Hyphenated words exist in real text. Any reason to use the hyphen as
the separator? If not, I would use a character just as tilde or
underscore that does not occur naturally in text.
On Fri, Feb 12, 2010 at 3:24 PM, Matthew Smith chedders...@gmail.com wrote:
I am generating static html for
Hyphenated words exist in real text. Any reason to use the hyphen as
the separator? If not, I would use a character just as tilde or
underscore that does not occur naturally in text.
I'm doing this to benefit SEO. What would be the best character to use to
separate words for page names
Hi all,
Trying to do a date compare on a file datelastmodified (retrieved through
CFDirectory).
If the file datelastmodified is older than 1 hour previous to Now, I want to
refetch the file.
In other words, if the file is posted at 9:00 AM, if it's presently 10:05 AM, I
want to get a new
Just change that EQ to LT and you'll be set.
On Sunday, November 29, 2009, m...@markleder.com m...@markleder.com
m...@markleder.com wrote:
Hi all,
Trying to do a date compare on a file datelastmodified (retrieved through
CFDirectory).
If the file datelastmodified is older than 1 hour
Thanks Barney, that worked!
Mark
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
PM
To: cf-talk
Subject: Re: Need help figuring out how to bill for on-call support I
provide to an ex-employer...
Rick, that actually sounds like what I've been banging around in my head.
My friend was thinking of an emergency on call rate for that reason, but
if it was a call saying the server
In a unique situation here (well, hopefully not)...
I've been helping a friend get his company automated and we've developed a
damned fine management system that handles mostly everything internally.
I've been working full-time for him on a very reduced salary for the past year
due to being
When you are on-call, are you expected to be available during the time
for immediate working on the problem or are you on a On call and will
get to it ASAP kind of thing?
If the former, bill it like straight time (since effectively, you are
at your computer waiting for the call to come in). If
...
Thoughts?
Rick
-Original Message-
From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
Sent: Saturday, November 21, 2009 12:01 PM
To: cf-talk
Subject: Re: Need help figuring out how to bill for on-call support I
provide to an ex-employer...
When you are on-call, are you expected
Rick, that actually sounds like what I've been banging around in my head.
My friend was thinking of an emergency on call rate for that reason, but if
it was a call saying the server was down and it involved a 10 minute call to
the hosting center, I would have to break out that hourly rate into
I have no control over this code
The only time parsing HTML with RegEx might be remotely viable is when you know
what that code will be - if the HTML is uncontrolled then using RegEx is a
futile effort.
RegEx is for dealing with Regular text, and HTML is not a Regular language -
even
List wrote at 17 November 2009 14:32:
Andy matthews, you're welcome.
Ah hah, that's a name I'm more familiar with.
testing
Roger. And excuse the previously poorly formatted code (it looked ok at
my end before sending but occasionally in Outlook 2007 when I copy and
paste from external apps
Peter Boughton wrote on Wed 18/11/2009 at 03:12:
The only time parsing HTML with RegEx might be remotely viable is when
you know
what that code will be - if the HTML is uncontrolled then using RegEx
is a futile effort.
RegEx is for dealing with Regular text, and HTML is not a Regular
Azadi Saryev wrote on 16 November 2009 at 17:58
you can do it with something like this:
cfset line='trtd class=la href=/blah.com/atd31
622td25
623td193 645td840 642td1.9 GB'
cfset cleanline = rereplace(line, 't[^]+', '|', 'all')
cfoutput#listfirst(cleanline, '|')# #listlast(cleanline,
Andy matthews, you're welcome.
-Original Message-
From: Mark Henderson [mailto:m...@cwc.co.nz]
Sent: Monday, November 16, 2009 4:29 PM
To: cf-talk
Subject: RE: Regex help with invalid HTML
Azadi Saryev wrote on 16 November 2009 at 17:58
you can do it with something like
testing
-Original Message-
From: Mark Henderson [mailto:m...@cwc.co.nz]
Sent: Monday, November 16, 2009 4:29 PM
To: cf-talk
Subject: RE: Regex help with invalid HTML
Azadi Saryev wrote on 16 November 2009 at 17:58
you can do it with something like this:
cfset line='trtd class=la
Calling all regex gurus. I've spent a little time on this so now it's
time to seek advice from the professionals. Here is an example of the
content I'm working with:
trtd class=la href=/abc.co.nz/atd52 363td73 815td5 122
265td2 166 760td471.47 MB
trtd class=la href=/xyz.co.nz/atd31 622td23
Will it always be a domain name you want to keep? And will the file size
always be at the very end of the line?
-Original Message-
From: Mark Henderson [mailto:m...@cwc.co.nz]
Sent: Sunday, November 15, 2009 8:38 PM
To: cf-talk
Subject: Regex help with invalid HTML
Calling all regex
lists wrote:
Will it always be a domain name you want to keep? And will the file
size
always be at the very end of the line?
Yes, and yes (confirmed all the TRs start on a new line).
Regards
Mark
~|
Want to reach the
you can do it with something like this:
cfset line='trtd class=la href=/blah.com/atd31 622td25
623td193 645td840 642td1.9 GB'
cfset cleanline = rereplace(line, 't[^]+', '|', 'all')
cfoutput#listfirst(cleanline, '|')# #listlast(cleanline, '|')#/cfoutput
and if you do not want any html in final
forms, the permissions on those are pretty well
locked down.
Has anyone out there seen this type of attack before, or is this something new?
Thanks for any help you can provide.
~|
Want to reach the ColdFusion community
Three of my CF7-driven sites just got hit this morning with an exploit that
I'm having trouble finding information on.
The attack did the following:
1) wrote 0 KB Application.cfm file to the web-root of the sites
2) wrote an onRequestEnd.cfm file (also to the web-root) that contained a
right now for testing but nothing fixes it.
Any help would be appreciated.
Thanks,
Steve
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive
I found the problem. Permissions. Permissions. Permissions!
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Monday, November 02, 2009 11:03 AM
To: cf-talk
Subject: CFForms don't display... Help!
All,
We moved from a CF7 server to a CF8 server this weekend. Now
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on passport_listing_id)
2 - my original join that was working except i
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on
Daniel,
You didn't post a link to the data.
Steve
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Sent: Wednesday, October 28, 2009 8:47 AM
To: cf-talk
Subject: Re: SQL Join help needed
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id
And here's the page with the data:
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
I seem to be having trouble posting today, so sorry if this shows up a bunch of
times.
~|
Want to reach the ColdFusion
, 2009 10:19 AM
To: cf-talk
Subject: Re: SQL Join help needed
And here's the page with the data:
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
I seem to be having trouble posting today, so sorry if this shows up a
bunch of times
Sorry about the multiple posts. I waited hours for the others to go through
and they didn't, then all at once.
That worked GREAT! Thank you very much. However, I don't really see any
differences from my attempts and yours except that you did the joins on the
FROM and I did it on the WHERE.
I think I should be doing an outer join. I have a set of data
(passport_registration) and I want to add a field from passport_attendance.
passport_registration is a total set because it's the people that registered
for the event. passport_attendance is a subset of those that attended the
This code isn't using inner/outer join notation, but the old style. Is
there a reason for this?
I would change the code to this:
CFQUERY NAME=passport_registration DATASOURCE=dpch
SELECT
a.passport_listing_id
,a.passport_registration_id
I meant to say - this is Oracle.
thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
]
Sent: Tuesday, October 27, 2009 1:54 PM
To: cf-talk
Subject: Re: SQL Join help needed
I meant to say - this is Oracle.
thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
the 'passport_attendance' table. I don't see
that in there and I am having difficulties adding it.
any help on that, please?
Here is the structure of passport_attendance:
passport_attendance_id NUMBER Primary Key,
date_added date,
person_scanning VARCHAR2(100
a.passport_listing_id = #url.passport_listing_id#
/CFQUERY
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Sent: Tuesday, October 27, 2009 2:51 PM
To: cf-talk
Subject: Re: SQL Join help needed
This code isn't using inner/outer join notation, but the old style
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
Steve
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Tuesday, October 27, 2009 3:11 PM
To: cf-talk
Subject: RE: SQL Join help needed
Sorry about that... Try
Hello,
I am developing using CF9. I am fetching RSS feed from twitter but XmlSearch is
unable to return array of entry elements in the xml.
Please look into the following code: I can't be using CFFEED tag, since this
project has to work on a CF 7 server.
cfset sourceUrl =
entry is the wrong entity for an RSS feed.
The entry you want is item
so you'd want xmlSearch(feed,//item)
hth
--
s. isaac dealey :: AutLabs
Creating meaningful employment for people with Autism
http://www.autlabs.com
ph: 817.385.0301
http://onTap.riaforge.org/blog
I think this will be to do with the default namespace in the xml document. A
quick google should tell you all you need to know on that, but the upshot is
that you will need to use a colon (e.g. a blank namespace) before entity
names, i.e.:
cfset items = XmlSearch(feed, '//:entry') /
HTH
Thanks for responding Isaac. I was using an Atom feed and therefore had to use
entry instead of item. It worked following the other advice.
Best
Sam
~|
Want to reach the ColdFusion community with something they want? Let them
I think this will be to do with the default namespace in the xml document. A
quick google should tell you all you need to know on that, but the upshot is
that you will need to use a colon (e.g. a blank namespace) before entity
names, i.e.:
cfset items = XmlSearch(feed, '//:entry') /
HTH
Thanks for responding Isaac. I was using an Atom feed and therefore
had to use entry instead of item. It worked following the other
advice.
Ahh, well I read RSS in your original message and had just gone and
double-checked the RSS link on my own twitter profile. :) Glad you got
it figured
This will replace everything that is not alphanumeric with a dash:
ProductPageName = rereplace( Form.PageName , '\W' , '-' , 'All' )
However, the above will change this that to this---that, if you would
prefer a single dash in situations like this, you can simply do this:
ProductPageName =
Hello:
Can anyone plz tell me why I cannot get the correct output from this query
It gives the following output shown below the query, when there should be no
repeats (DISTINCT appears to not be working)
cfquery datasource=#datasource# name=list_audit_orgs
SELECT
Totally ignoring the data/distinct question for a moment, when using cfoutput
group the query data must be sorted correctly, or you will not get the right
results.
You need to ORDER the query results by the same column you're using in your
group. If you are grouping by audit_org_type_id,
AWESOME - simple, easy fix - thanks Leigh ... I had forgotten that requirement
Leigh cfsearch...@yahoo.com 10/22/2009 11:55 AM
Totally ignoring the data/distinct question for a moment, when using cfoutput
group the query data must be sorted correctly, or you will not get the right
results.
Thanks for responding Brian but Leigh's tip made it work
Brian McCairn brian.mcca...@medicapp.eu 10/22/2009 12:03 PM
do you need those other columns?
does
cfquery name=unique_info dbtype=query
SELECT distinct audit_org_type FROM list_audit_orgs
/cfquery
work?
do you need those other columns?
does
cfquery name=unique_info dbtype=query
SELECT distinct audit_org_type FROM list_audit_orgs
/cfquery
work?
~|
Want to reach the ColdFusion community with something they want? Let them
of advertisements to only pull the ads that might be in the
zip radius. Any thoughts as to what might be easiest?
Thanks for the help...
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
a specified radius
and then spits the results out as a list. I want to be able to use that list
to search a database of advertisements to only pull the ads that might be in
the zip radius. Any thoughts as to what might be easiest?
Thanks for the help
Once you have a list, you can do the following directly in the database
clause:
WHERE zipCode IN ( cfqueryparam cf_sql_type=cf_sql_varchar
value=#zipList# list=true / )
~|
Want to reach the ColdFusion community with
I am just going over some old code, I found the following...
productPageName = Replace(#FORM.pageName#, ,-,All);
productPageName = REReplace(#productPageName#,[.*+?^${}()|[\]/\\],,All);
its seems like its create a page name but removed spaces and special characters
i.e. this page! becomes
There are 2 separate thing being done with that code.
1. Its replacing spaces with a -
2. Its removing a bunch of 'special' characters.
There really is no way to do this in one live of code. However, if
this is something you woudl need to use in more than one place, you
can easily put these
If you want it in one line, just combine them:
productPageName =
Replace(REReplace(FORM.pageName,[.*+?^${}()|[\]/\\],,All),
,-,All);
BTW, you don't the the #'s inside of a function unless the variable is
in quotes.
Thanks,
Eric Cobb
http://www.cfgears.com
Glyn Jackson wrote:
I am just
Makes sense, thanks you.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327452
also, if you are replace all non alpha-numeric characters you can do
this:reReplace(arguments.txt,
'[^[:alnum:].]', '-', 'all');
~Mahcsig
On Wed, Oct 21, 2009 at 8:57 AM, Glyn Jackson glyn.jack...@newebia.co.ukwrote:
Makes sense, thanks you.
Anyone want to take a gander at this?
http://www.opensourcecf.com/cfopenchat/layout.html
In the above layout, I only want to hard code the width and height in
the outermost div (the inside of that div will be code generated)
This works great in Chrome and IE.. but not Firefox... and I don't
Rick Root wrote:
Anyone want to take a gander at this?
http://www.opensourcecf.com/cfopenchat/layout.html
In the above layout, I only want to hard code the width and height in
the outermost div (the inside of that div will be code generated)
This works great in Chrome and IE.. but not
Have you changed the JVM from the one shipped with CF8 If so, the
java tools jar from the alternate JVM needs to be copied to CF for
some webservice calls to work properly (as well as a few other
things).
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
Thanks
On most platforms, yes, CF uses its own.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/10/14 Robert Nurse rnu...@gmail.com:
Have you changed the JVM from the one shipped with CF8 If so, the
java tools jar from the alternate JVM needs to be copied to CF
Thanks again Tony. Your help is much appreciated...
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Tuesday, October 13, 2009 5:33 PM
To: cf-talk
Subject: Re: Looking for jQuery Form Help...
You just need to point to each form element that you want
Take a look at the link below. It's a screen shot of a form where the
Shipping form fields can be toggled on/off. I haven't been able to find
(or search properly) for jQuery code that does something similar. Can anyone
point me in the right direction? Thanks, Che
I should add that by default, the bottom form fields in my example screen
shot are off. That is, they are visible, but you can't enter any data.
When turned on, only then can data be entered. Thanks in advance to anyone
that can help.
-Original Message-
From: Che Vilnonis [mailto:ch
Sure:
input type=radio onclick=showHide() value=true
name=UseDifferentShippingAddress
div id=DifferentShippingAddress style=display:none
inputs with values
/div
function showHide(){
if($(this).is(:checked)){
$(#DifferentShippingAddress).show();
}
else{
$(#DifferentShippingAddress).hide();
}
}
this is using disabled to keep them visible:
input type=radio onclick=showHide() value=true
name=UseDifferentShippingAddress
div id=DifferentShippingAddress
inputs with values
/div
function showHide(){
if($(this).is(:checked)){
$(input, select, textarea,
In your function if the radio is checked (or unchecked depending on the ready
state), enable the collection of form elements by using
$(input[name=formelement]).attr(disabled,true);
~|
Want to reach the ColdFusion community
Tony, thanks so much! Tested EQ What I needed!
-Original Message-
From: Tony Bentley [mailto:t...@tonybentley.com]
Sent: Tuesday, October 13, 2009 11:32 AM
To: cf-talk
Subject: Re: Looking for jQuery Form Help...
Tested:
input type=radio onclick=showHide(true) value=true
name
Tested:
input type=radio onclick=showHide(true) value=true
name=UseDifferentShippingAddress Disable
input type=radio onclick=showHide(false) value=true
name=UseDifferentShippingAddress checked=checked Enable
div id=DifferentShippingAddress input name=shippingaddress
disabled=true //div
for jQuery Form Help...
input type=radio onclick=showHide(true) value=true
name=UseDifferentShippingAddress Disable
input type=radio onclick=showHide(false) value=true
name=UseDifferentShippingAddress checked=checked Enable
div id=DifferentShippingAddress input name=shippingaddress
disabled=true
You just need to point to each form element that you want to disable. For
instance, if you setup a parent container then you can command each matching
element to disable:
function disableForm(bool){
$(#DivWithInputs input,#DivWithInputs textarea).each(function(){
$(this).attr(disabled,bool);
Since the original question was cross-posted to the jquery list, I
might as well cross-post my answer:
Are you using the disabled attribute on the inputs that you want to
turn off?
If so, you can add/remove it.
http://www.it.dev.duke.edu/public/disabled.html
Thanks for the links Dave! We're running CF8 (multi-server option) on a Unix
box. All
the JAR files mentioned in the Adobe kb link are all listed under the CF
Server Java
Class Path in the administrator. Therefore, they should be available during
compilation.
I wonder if these
Hi All,
I'm using CFINVOKE to consume an enterprise web service. Now, I'm not well
versed on web services. But, from reading the CF documentation on them, you're
supposed to be able to use CFINVOKE... to access them. So, in my test page I
have:
cfinvoke
My question is, why is CF trying to compile Java code if this web service is
available to the enterprise?
Whenever you invoke a web service, CF needs to create local classes to
represent the remote objects exposed by the web service. This is how
most web service clients work.
Hi,
Flex dev here - wannabe CF coder :-)
I need to return some JSON to a Flash Lite client, the format I'd like
to produce looks like this:
{
total: 100,
items:
[
{id: 0, title: Some Title},
{id: 0, title: Some Title},
Create a struct, with keys 'total' and 'items'. 'items' should be a
struct of structs, with each 'record' having an 'id' and 'title'. When
making the request of your cfc method, which should be set to return
this struct, include another parameter to the request: returnFormat = JSON
= {};
thisRow[id] = qryResult[id][i];
thisRow[title] = qryResult[title][i];
arrayAppend(returnStruct[items],thisRow);
}
return serializeJSON(returnStruct);
Good Luck.
~Brad
Original Message
Subject: JSON help
From
],thisRow);
}
return serializeJSON(returnStruct);
Good Luck.
~Brad
Original Message
Subject: JSON help
From: Stefan Richter ste...@flashcomguru.com
Date: Fri, October 09, 2009 10:39 am
To: cf-talk cf-talk@houseoffusion.com
Hi,
Flex dev here - wannabe CF
];
thisRow[title] = qryResult[title][i];
arrayAppend(returnStruct[items],thisRow);
}
return serializeJSON(returnStruct);
Good Luck.
~Brad
Original Message
Subject: JSON help
From: Stefan Richter ste...@flashcomguru.com
Date: Fri, October 09, 2009
ridiculously simple it's scary.
~Brad
Original Message
Subject: Re: JSON help
From: Stefan Richter ste...@flashcomguru.com
Date: Fri, October 09, 2009 11:18 am
To: cf-talk cf-talk@houseoffusion.com
I've now done the following - anything wrong with that?
cfset obj = StructNew
My question is, why is CF trying to compile Java code if this web
service is available to the enterprise?
Whenever you invoke a web service, CF needs to create local classes
to
represent the remote objects exposed by the web service. This is how
most web service clients work.
Have you changed the JVM from the one shipped with CF8 If so, the
java tools jar from the alternate JVM needs to be copied to CF for
some webservice calls to work properly (as well as a few other
things).
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
20, 2009 1:30 PM
To: cf-talk
Subject: Re: Help: DSN across VPN with virtual IP
Mark,
Thanks for the suggestions. I had just emailed them last night about the
other 2 services, and am prepping a test file to check on reading/writing
just as you suggest. Glad to see I'm thinking down the right
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: Kris Jones [mailto:kris.jon...@verizon.net]
Sent: Saturday, September 19, 2009 5:49 PM
To: cf-talk
Subject: Help: DSN across VPN with virtual IP
Hi all,
I'm trying to help a client
Mark,
Thanks for the suggestions. I had just emailed them last night about the
other 2 services, and am prepping a test file to check on reading/writing
just as you suggest. Glad to see I'm thinking down the right path on this
one. I'll also send the suggestion on the hosts file entry. Never
Hi all,
I'm trying to help a client work out an interim fix for a security issue.
They need to move the administrative interface for some CF applications off
of their public-facing website. The applications store some sensitive data
that require there be no public interface available
to
interface with the DB and aren't creating lots of objects themselves.
I've also looked at SeeFusion and FusionReactor trials to see if they can help
me but neither of them seem to be able to tell me how much memory each request
is using etc, they both seem to be too general for my needs
Now() to
CreateDate(Year(Now()),Month(Now()),Day(Now())) has solved the memory leak
completely.
Phew!
Paul
-Original Message-
From: Paul Vernon
Sent: Monday, September 14, 2009 6:55 PM
To: cf-talk
Subject: Need help pinpointing an aggressive memory leak
I've got a problem
Hello. I'm hoping someone here can help me.
I have a search form that is submitted (with a number of criteria but for this
purpose) with a proposal number (Pipe_id) and what type of file the user is
looking for (proposal (chkProposal), solicitation (chkSolicitation), debrief
(chkDebrief
Traci,
For the recordset that you already have.
Pipe_id File_id File_title
=
989910proposalrevision.doc
989910tableofcontents.doc
989911
Brad, I'll have to look at your response in much greater detail, but I
can tell you this.
Currently, I'm running a CF script that populates a prospect_export
table once a day. The initial query returns 25,785 rows, which gets
flattened into 20,265 rows for reporting purposes.
Ultimately I'd
I'm hoping someone here can point me in the right direction. I'm
doing something in CF that I really need to be doing in SQL:
I need to flatten this data:
select
A.entityid,
A.MEMBERID,
A.RELTYPE,
A.leaderFlag
from
Hi Rick,
This is where the limiting nature of SQL comes in--SQL is a set language
and has no (or very limited) looping/reshaping capability. Unless MS
has extended their SQL in ways I'm not aware of, this would be nearly
impossible. That's where the power of CF comes in.
--Ben
Rick Root
This is where the limiting nature of SQL comes in--SQL is a set language
and has no (or very limited) looping/reshaping capability. Unless MS
has extended their SQL in ways I'm not aware of, this would be nearly
impossible. That's where the power of CF comes in.
That's not true. You can
You might also take a look at ms sql 2005's row_number() function. You may be
able to partition the data and use row_number() to limit the returned records.
http://msdn.microsoft.com/en-us/library/ms186734.aspx
601 - 700 of 12194 matches
Mail list logo