5, 2013 12:31 PM, "Dakota Burns" >
> wrote:
>
> >
> > I am trying to use an HTML Select form component to select & go to a URL.
> > I'm using the attached jQuery to accomplish this. The selection opens a
> new
> > window to the intended URL b
gt;
> Next, when you remove the location change, "nothing happens" because you're
> explicitly saying to do nothing. Remove the function from the submit() and
> watch the magic take place.
>
> HTH
>
> Sent from a mobile something
> On Jun 5, 2013 12:31 PM, "
tion from the submit() and
watch the magic take place.
HTH
Sent from a mobile something
On Jun 5, 2013 12:31 PM, "Dakota Burns" wrote:
>
> I am trying to use an HTML Select form component to select & go to a URL.
> I'm using the attached jQuery to accomplish this. The se
I am trying to use an HTML Select form component to select & go to a URL.
I'm using the attached jQuery to accomplish this. The selection opens a new
window to the intended URL but the submit function doesn't post the hidden
name/value pairs. I suspect my syntax is a bit in conf
Sorry if the title is a little confusing but I'll try to explain it clearly
here. Also, I'm using ColdBox for this project and I'll be posting it to
the ColdBox list so sorry in advance if you get it twice.
So the idea here is that I have a select box that will have more than on
> I am trying to connect to MS access 2007 from my cf 9.0 and getting following
> error.
Is there a reason you're not using SequeLink or the built-in JET driver?
Are you running a 64-bit version of CF?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig
Hi,
I am trying to connect to MS access 2007 from my cf 9.0 and getting following
error.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or
buffer length
The root cause was that: java.sql.SQLException: [Microsoft][ODBC Driver
Manager] Invalid string or buffer length
Co
Actually this code worked once I corrected the spelling of a variable. Sorry I
did not update the list.
BRuce
>>
> Bruce
>
> AJAX might be better here.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Ado
ns[resortID.options.length] = new
> Option('#Resort_Name#','#resort_ID#');
> </cfoutput>}
>
> }
>
>
>
>
> Here are the select lists:
>
> onchange="
ns[resortID.options.length] = new
> Option('#Resort_Name#','#resort_ID#');
> </cfoutput>}
>
> }
>
>
>
>
> Here are the select lists:
>
> onchange="
ort_Name#','#resort_ID#');
</cfoutput>}
}
Here are the select lists:
Select...
the BallCarrier column? Would
cfsqltype="CF_SQL_VARCHAR" be more appropriate?
HTH,
Carl
On 6/10/2011 6:14 AM, Jim Brundle wrote:
> I'm doing a look up like this:
>
>
>SELECT Formation, Play, BallCarrier, YardsGained, Result
>FROM PlaysCalled
>WH
Yes, and if this is form input, you should be using cfqueryparam anyway.
Please see the news for Sony's latest data hack, which was simple web-based
SQL injection. cfsqltype will need to match column datatype in each case.
SELECT Formation, Play, BallCarrier, YardsGained, Result
I'm doing a look up like this:
SELECT Formation, Play, BallCarrier, YardsGained, Result
FROM PlaysCalled
WHERE (((PlaysCalled.Formation)="#Form.Formation#") AND
((PlaysCalled.Play)="#Form.Play#") AND
((PlaysCalled.BallCarrier)="#Form.BallCarrier#"));
Mark, there is an excellent SQL tutorial here: http://www.w3schools.com/sql/
If you figure out exactly how joins work, it will make writing SQL so
much easier for you.
Sub-selects like Greg used are also very useful.
A few hours spent on this site will save you hours of struggle later.
On Thu,
it to produce the same results, which I will
do.
Thanks again,
Mark
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Thursday, May 26, 2011 11:48 AM
To: cf-talk
Subject: Re: cfquery select question
If they all return 1 row use this..
select * from table3 t3
where
If they all return 1 row use this..
select * from table3 t3
where t3.ID = (
select t2.ID
from table2 t2
where t2.productcode = (
select t1.productcode
from table1 t1
where t1.ordernumber = [whatever]
)
)
If they
SELECT DISTINCT table3.ID, table3.Company
FROM table3 INNER JOIN
table2 ON table3.ID = table2.t2_ID INNER JOIN
table1 ON table2.ordernumber = table1.ordernumber
WHERE (table1.productcode LIKE '%a certain string%')
On Thu, May 26,
) that has(have)
purchased table1.productcode.
Have Googled and read about how a single select with JOIN and/or UNION would
achieve these results, but they also mention how I should essentially "start at
the end" and work my way backwards, so to speak. Can't quite get my head aro
ot;You must select at least one drop-down option to continue.");
return false;
} else {
return true;
}
On 5/2/2011 6:18 AM, Kevin Parker wrote:
> Have an interesting problem that no end of trawling the net has solved for
> me.
>
> Have a form that has 6 select boxes on it. I
Have an interesting problem that no end of trawling the net has solved for
me.
Have a form that has 6 select boxes on it. I want to check that the user has
selected at least one option from any of the six select boxes (doesn't
matter which one but must be at least one from any dro
ebruary 17, 2011 5:04 AM
To: cf-talk
Subject: Re: SELECT - Option selected
I have a simple one:
selected="selected"
>AM
selected="selected"
>PM
~|
Order the Adobe Coldfusion Anthology now!
http://www.a
Sent: Thursday, February 17, 2011 7:58 AM
To: "cf-talk"
Subject: Re: SELECT - Option selected
I couldn't agree more. I abandoned CFFORM years ago.
Sent from my iPhone
On Feb 17, 2011, at 6:05 AM, Michael Grant wrote:
>
> In my experience CFForm is more trouble than it'
I couldn't agree more. I abandoned CFFORM years ago.
Sent from my iPhone
On Feb 17, 2011, at 6:05 AM, Michael Grant wrote:
>
> In my experience CFForm is more trouble than it's worth. I generally just
> use regular forms + jquery to get elegant client-side validation. Much more
> lightweight
In my experience CFForm is more trouble than it's worth. I generally just
use regular forms + jquery to get elegant client-side validation. Much more
lightweight and gives much more granular control over your form.
On Thu, Feb 17, 2011 at 5:27 AM, Torrent Girl wrote:
>
> The solution was not t
The solution was not to use CFFORM at all. it now works.
> I have a simple one:
>
>
>
> selected="selected"
> >AM
> selected="selected"
> >PM
>
>
>
> >depends on cfselect...
> >
> >in simple cfselect - one based on an in-page query, for example - you
>
> >can provide a value in the 'se
I have a simple one:
selected="selected"
>AM
selected="selected"
>PM
>depends on cfselect...
>
>in simple cfselect - one based on an in-page query, for example - you
>can provide a value in the 'selected' attribute and an with
>that value will be pre-selected.
>
>advanced cfselect - one
javascript work-arounds for that: google
'cfselect binding selected' and you will find them
Azadi
On 16/02/2011 21:34 , Torrent Girl wrote:
> Does this not work on cfselect?
>
>
>> If you are talking the HTML select element it is selected="selected"
>>
>&
Does this not work on cfselect?
>If you are talking the HTML select element it is selected="selected"
>
>Sent from my iPhone
>
>On Feb 15, 2011, at 4:47 PM, Torrent Girl wrote:
>
>>
~|
Or
If you are talking the HTML select element it is selected="selected"
Sent from my iPhone
On Feb 15, 2011, at 4:47 PM, Torrent Girl wrote:
>
> this is an old post but I am pulling my hair out as well.
>
> Does anyone know the answer to the select="true", selec
this is an old post but I am pulling my hair out as well.
Does anyone know the answer to the select="true", select="selected" problem?
It is not working in IE or FF for me.
TIA
~|
Order the Adobe Cold
that worked. write me if you want a copy ...
On 11/11/2010 10:15 AM, John M Bliss wrote:
> Little find-and-replace on this and you should be good to go:
> http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/
>
> On Thu, Nov 11, 2010 at 12:06 PM, Rick C
Rick Colman wrote:
>
> I need to provide world-wide country postal abbreviations in a drop-down
> select box.
I don't know of one already to go. Since countries can change, I
use the UN country code list as the starting point. It isn't that
hard with cut-n-paste to
> I need to provide world-wide country postal abbreviations in a drop-down
> select box.
>
> there must be one of those out there, although I have searched.
>
> Anybody know where to get one.
It's just HTML, right? So if you see a site with one, view source and
copy the ap
Rick, do you mean something like this? Most are there except Axis-of-Evil
countries.
Afghanistan AF
Albania AL
Algeria DZ
American Samoa (U.S. Ter.) AS
Andorra AD
Angola AO
Anguilla AI
Antigua & Barbuda AG
Antilles (Netherland) AN
Argentina AR
Armenia AM
Aruba AW
Ascension GB2
Australia AU
Austri
check cflib.org
On Thu, Nov 11, 2010 at 6:15 PM, John M Bliss wrote:
>
> Little find-and-replace on this and you should be good to go:
>
> http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/
>
> On Thu, Nov 11, 2010 at 12:06 PM, Rick Colman wrote
Little find-and-replace on this and you should be good to go:
http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/
On Thu, Nov 11, 2010 at 12:06 PM, Rick Colman wrote:
>
> I need to provide world-wide country postal abbreviations in a drop-down
> select box.
I need to provide world-wide country postal abbreviations in a drop-down
select box.
there must be one of those out there, although I have searched.
Anybody know where to get one.
TNX.
rick.
~|
Order the Adobe Coldfusion
es [mailto:james.hol...@gmail.com]
> Sent: Friday, November 05, 2010 7:31 AM
> To: cf-talk
> Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype
>
>
> Which version of CF are you using?
>
> --
> WSS4CF - WS-Security framework for CF
> http://wss4cf.riaf
CF8
-Original Message-
From: James Holmes [mailto:james.hol...@gmail.com]
Sent: Friday, November 05, 2010 7:31 AM
To: cf-talk
Subject: Re: Oracle 11g Upgrade Unable to select from CLOB datatype
Which version of CF are you using?
--
WSS4CF - WS-Security framework for CF
http
Which version of CF are you using?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 5 November 2010 15:50, Noveta Wimbley wrote:
>
> We have just upgraded from Oracle 10g to 11g. Now we have an application that
> will not select from clob datatype column.
&
We have just upgraded from Oracle 10g to 11g. Now we have an application that
will not select from clob datatype column.
We are getting the following error:
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]No more data available to read.
The error occurred in E:\Collab\iweb
On Sat, May 29, 2010 at 4:50 AM, Phillip Perry wrote:
> Thank you. I that helps alot. Totally missed the selected=selected
> error ><. Can I use the same code for the radio options?
checked="checked" (same for checkbox and radio button)
--
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, I
"Oh and as a matter of preference (and for some code checking tools) I hate
it when tags are embedded in other tags."
Write a UDF that you can embed in the tag. You'll never have to worry about
embedding again.
Something like isChecked(chkValue,qryValue) which would return an empty
string or "c
A little different for radios: use checked="checked", but, yes,
otherwise the same.
checked="checked" />#thisText#
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz
Thank you. I that helps alot. Totally missed the selected=selected
error ><. Can I use the same code for the radio options?
Phil
On Thu, May 27, 2010 at 4:22 PM, Yuliang Ruan wrote:
>
> btw, it should be just selected not selected="selected"Than
>
> "clothes">SELECTED>Clothes
>
> if your list
> How do people feel about this:
>
> is "personal" ? 'checked="checked"' : '' # />
I can't speak for anyone else, but I think the ternary operator is one
slippery step down a dangerous slope. At the very bottom of that slope
lies Perl.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
On Thu, May 27, 2010 at 1:37 PM, DURETTE, STEVEN J (ATTASIAIT)
wrote:
>
> checked="checked" />
>
>
> Personal
How do people feel about this:
--
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, Inc. -- http://getrailo.com/
An Architect's View -- http://corfield.org/
"If
PM
To: cf-talk
Subject: Re: How to make a select option tag selected in CF?
oh for radiobuttons it's
CHECKED>Personal
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology
> btw, it should be just selected not selected="selected"
That is no longer necessarily the case. It will depend on the doctype.
For XHTML 1.0, it should be:
...
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Veteran-Owned Small B
best to
use selected="selected"
Steve
-Original Message-
From: Yuliang Ruan [mailto:yuliangr...@hotmail.com]
Sent: Thursday, May 27, 2010 4:23 PM
To: cf-talk
Subject: Re: How to make a select option tag selected in CF?
btw, it should be just selected not selected="selected&q
oh for radiobuttons it's
CHECKED>Personal
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/g
btw, it should be just selected not selected="selected"
SELECTED>Clothes
if your list of options is long and u need it to be hardcoded, u should put it
into a array of struct. i.e.
SELECTED>#thisChoice.text#
of course even better would be these in a lookup db table
~~~
and the radio
buttons are confusing me. It's been a while since I used CF for this
so I forget. Below is the select and radio button form fields:
Choose
>From Below
Clothing Store
Sporting Goods Store
Hobby Shop
orget. Below is the select and radio button form fields:
Choose
>From Below
Clothing Store
Sporting Goods Store
Hobby Shop
Computer Related Sales
Medical Profession
Groce
It worked! Thank you.
>This is like outputting url_sizes.attributeId outside a cfoutput tag, it
>only gets the first item. You need to set the attributeId column into a
>list:
>
>
>
>On Tue, May 11, 2010 at 12:04 PM, Dan Sullivan <
>coldfusiondevelope...@gmail.com> wrote:
>
>> listFind(url_sizes.
This is like outputting url_sizes.attributeId outside a cfoutput tag, it
only gets the first item. You need to set the attributeId column into a
list:
On Tue, May 11, 2010 at 12:04 PM, Dan Sullivan <
coldfusiondevelope...@gmail.com> wrote:
> listFind(url_sizes.attributeId, id)
>
I'm in edit mode in my form, passing and URL.id value which is a product id.
I'm trying to get the atribId values: 17, 19, 22, 61, 74 to populate my
multiple select box as selected, but it's only working for the first value 17.
select name, id
from giftAttributes
select g
> I just want 1 LeadID and 1 Email out of the 4 records.
Which one LeadID? If you want the min, just do:
SELECT Email MIN(LeadID) AS LeadID
FROM Leads
group by Email
On Wed, Mar 17, 2010 at 11:25 AM, Casey Dougall <
ca...@uberwebsitesolutions.com> wrote:
>
> Hi,
>
>
y 1 column when really want to select 2 or more at the
same time. :-(
SELECT distinct (Email), LeadID
FROM Leads
group by Email
I just wish that would work. Mind you there a bunch of additional columns so
it's more like needing
SELECT distinct (Email), LeadID, FirstName, LastName
FRO
I am trying to utilize CF8's related selects and would appreciate some
guidance.
Here is the data
Width: 6 inch and 8 inch
Colors:
6 inch colors: white, tan, beige
8 inch colors: green, black, grey
Thickness:
6 inch thickness: .012, .020, .028
8 inch thickness: .030, .040, .044
When a width
Mahcsig wrote:
> It looks like the getGPDesc function is expecting a number. Selecting
> multiple items will return a list of numbers separated by commas. The code
> calling getGPDesc will need to take this into consideration.
I would expect to see the error *after* the form is submitted though -
to the
> getGPDesc function is not of type numeric.
>
> OK - so when loading the page with this on it, what's difference when
> multiple="no" vs multiple="yes" in the below?
>
>
>id="sendGROUP"
> multiple="no"
ction is not of type numeric.
OK - so when loading the page with this on it, what's difference when
multiple="no" vs multiple="yes" in the below?
Select a Group
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4811 (20100127
I should add...
If I IGNORE the error - I can make multiple selections as needed and the
query works as expected when the form is submitted.
> Here's my two selects. This is working - no problems...
>
> id="theCATS"
>bind="cfc:art.getCATS()"
Here's my two selects. This is working - no problems...
Select a Category
Select a Group
But - I need to be able to make *multiple* selections. If I change the
second select to allow multiples:
Select a Group
I get "Error invoking art.cfc. Internal Server Error
rald Guido [mailto:gerald.gu...@gmail.com]
Sent: Monday, January 04, 2010 2:47 PM
To: cf-talk
Subject: Re: line-through in select tag
This worked on FF but not IE 7 (got figure).
#dollarFormat(productData.Price)#
On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray wrote:
>
> Anyone know of a way t
This worked on FF but not IE 7 (got figure).
#dollarFormat(productData.Price)#
On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray wrote:
>
> Anyone know of a way to get a CSS line-through in an HTML select tag?
>
> I tried this but it does not work.
>
>
> style="te
Anyone know of a way to get a CSS line-through in an HTML select tag?
I tried this but it does not work.
#dollarFormat(productData.Price)#
~|
Want to reach the ColdFusion community with something they want? Let them know
on
In CFEclipse, you can double-click on a tag in the outline view, and
it will select the whole thing (there's also an icon for it in the
outline view).
It's a little dodgy, so I'll see if it's clean-up-able before the next release.
I need to add some context menus anyways,
>1) Does this functionality exist in the newer versions of the Aptana /
>CFECLIPSE IDE?
Not afaik.
>2) If not, then is there some similar type of functionality that will allow
>me to select an entire tag and perform an indent / outdent?
You can use jump to matching tag to
Howdy, Folks!
I am looking to upgrade to Aptana / CFECLIPSE, and desperately need it to
have the "Select Full Tag" functionality like HomeSite does.
So, this brings me to my questions:
1) Does this functionality exist in the newer versions of the Aptana /
CFECLIPSE IDE?
|#Variables.mySecondCol#
> > >
> > > Since the first column will now be a fixed length everything should
> line
> > > up.
> > >
> > > Steve
> > >
> > >
> > > -Original Message-
> > > From: ColdFusion Developer [m
On Wed, Dec 16, 2009 at 5:03 PM, ColdFusion Developer
wrote:
>
> Tried that as well. Does not line up.
>
> Ex:
>
> 3M | XYZ Corporation
> ABCDY | AB Corporation of Delaware
>
> The first one is 2 characters and 5 spaces
> The second one if 5 characters and 2 spaces
>
> Both equal 7 spa
ables.myTempFirstCol#|#Variables.mySecondCol#
> >
> > Since the first column will now be a fixed length everything should line
> > up.
> >
> > Steve
> >
> >
> > -Original Message-
> > From: ColdFusion Developer [mailto:cfdev2...@gmail
> Sent: Wednesday, December 16, 2009 4:29 PM
> To: cf-talk
> Subject: Two Column Select Box?
>
>
> Anyone develop a selectbox that shows two columns of data but only one
> value?
>
> Example:
>
> XYZ | XYZ Corporation
&g
-
From: ColdFusion Developer [mailto:cfdev2...@gmail.com]
Sent: Wednesday, December 16, 2009 4:29 PM
To: cf-talk
Subject: Two Column Select Box?
Anyone develop a selectbox that shows two columns of data but only one
value?
Example:
XYZ | XYZ Corporation
ABCD | AB Corporation of
Anyone develop a selectbox that shows two columns of data but only one
value?
Example:
XYZ | XYZ Corporation
ABCD | AB Corporation of Delaware
Goal is to still have the two columns aligned as well.
TIA!
~|
Want
btw.
how other then this list could i have found the answer?
i tried google = fail
On Thu, Nov 12, 2009 at 1:30 PM, Paul Ihrig wrote:
> Dan.
> Thank You.
>
~|
Want to reach the ColdFusion community with something they want? Let
Dan.
Thank 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:328309
Subscripti
On Thu, Nov 12, 2009 at 11:08 AM, Paul Ihrig wrote:
>
> so just to clarify.
> the show hide js works fine on its own, just doesn't check or see the
> default value from the existing data
>
>
~|
Want to reach the ColdFusion com
Paul,
You need to "trigger" the change method when you initialize your code:
On Thu, Nov 12, 2009 at 11:07 AM, Paul Ihrig wrote:
>
>
>$(function(){
>$("#prt_type").change(function () {
>var val = $(this).val();
>switch(pa
so just to clarify.
the show hide js works fine on its own, just doesn't check or see the
default value from the existing data
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fus
ok this is kinda like a 2 select related, but not really..
i want to show a 2nd selecty box only if the first select box is value 6
This works great on change when you are in the form.
but if i am updating the form. it doesn't see the default value..
which is in a var called StrType
prt_ty
got it.
~|
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:326011
Subscription: http
i can default the first select just fine.
but the 2nd one is driving me nuts...
http://63.144.103.199/selectbox_binds/region_territory.cfm
the 2 slects part works just fine.
as dowes defaulting the first cfselect
var selectregiondone
and the function
SELECT territory_id, region_info_id, territory_id AS Tidx
FROM region_territory_lookup
WHERE (region_territory_lookup.region_info_id = )
ORDER BY territory_id
Territory: (id:#attributes.territory_id#)
~|
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/
t and
> the correct description shows up depending on what you select in
> "sendGROUP". Ideas?
>
> Here's what I've got:
>
> My CFC file:
>
>
>
>
>
>
>
>
>
>
>
Almost working correctly.
When the page first loads, I get an alert:
"The GROUPS_ID argument passed to the get is not of type numeric"
If I dismiss the alert, then the page functions normally after that and
the correct description shows up depending on what you select in
"se
> http://www.forta.com/blog/index.cfm/2007/6/4/ColdFusion-Ajax-Tutorial-4-Partial-Page-Updates
This is *exactly* what I'm looking for!
Thanks very much!
~|
Want to reach the ColdFusion community with something they want? Let th
Cat into 1
Cat into 2
Cat into 3
Adrian
> -Original Message-
> From: Les Mizzell [mailto:lesm...@bellsouth.net]
> Sent: 13 May 2009 18:23
> To: cf-talk
> Subject: OT (maybe): Display additional info from a Select before Form
&
Uncle Ben has a tute on that here:
http://www.forta.com/blog/index.cfm/2007/6/4/ColdFusion-Ajax-Tutorial-4-Partial-Page-Updates
On Wed, May 13, 2009 at 1:23 PM, Les Mizzell wrote:
>
> For a select box (simplified):
>
>
>
> #getCATS.catNAME#
>
>
>
>
Are you on CF 8? If so one way to do it is use CFdiv and have it call a
template or bind to a CFC to display the comments.
#getCATS.catNAME#
>
>
OR
On Wed, May 13, 2009 at 1:23 PM, Les Mizzell wrote:
>
> For a select box (simplified):
>
>
>
>
For a select box (simplified):
#getCATS.catNAME#
I need to display additional info for each selection when the selection
is made - before the form is submitted.
So if you've got
Record 1
Record 2
Record 3
...and somebody selects "Record 2" - I need the
Oracle worries about the where clause before the sort (so it has to
sort less rows).
I filled ten rows in a table with value from 1 to 10 in random order,
then ran this:
SELECT STUFF
FROM ATABLE
WHERE ROWNUM < 9
ORDER BY STUFF DESC
If it works as you say, I should get 10-3 in order. I did
I'd much rather deal with Oracle's that SQL Server's. At least my
experience has been it is far easier for me to deal with "issues" with
Oracle v. ones with SQL Server.
On Mar 12, 2009, at 10:06 AM, Ian Skinner wrote:
>
>>
>>
>
> P.S.
> Sure shows how many developers don't need to work with
You really don't need to use analytics in this case.
The inline subquery presented by Mr. Holmes is the correct one.
See
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/pseudocolumns009.htm#i1006297
Although this is for 11g, it holds for the other verisons as well
You could select the rows with sort descending, then use query of
queryies to sort them back into the asc order couldnt you?if
you're only manipulating 50 records or so the qofq wouldnt take long.
Mike Kear
Windsor, NSW, Australia
http://afpwebworks.com
AFP Webworks
> I trie
I can verify in 9.i it doesn't work states group by function is not allowed
there.
On Thu, Mar 12, 2009 at 11:11 AM, Jason Fisher wrote:
>
> I don't have access to an Oracle database, so, no. Thankfully, I haven't
> had to develop on Oracle for the past several years, after spending several
>
1 - 100 of 1716 matches
Mail list logo