Does anyone know if its possible to cancel a running query in CF?
I found this article (http://www.onjava.com/lpt/a/4938) which describes how
to do it in java, so i'm guessing it must be possible in CF, but has anyone
done it?
Cheers
Bert
p.s. This is similar to a thread just started about
On Thursday 22 September 2005 17:25, Bryan Stevenson wrote:
mumble
cfmail multi-part with embedded images
/mumble
Somebody bitter Tom?? ;-)
Yeah, I found the bug in the beta (i.e. you couldn't do it because cfmailparam
was broken), and it wasn't fixed.
So we had to use a custom tag
ah, I see. I reread your original posts and it said that I should remove the
brackets, which I had not. Once I did that it worked fine.
thanks!
This is weird, I tried myself and I got eveything: 7 records, the last
one being bones, y'see.
Are you sure you put |$ at the end of RE2 ? If you
I've had mixed results with that. From the docs :
Maximum number of seconds that each action of a query is permitted to
execute before returning an error. The cumulative time may exceed this
value.
For JDBC statements, ColdFusion sets this attribute. For other
drivers, check driver
On Thursday 22 September 2005 22:05, Andy Matthews wrote:
Hey Ryan...
http://weitz.de/regex-coach/ is damn handy too.
--
Tom Chiverton
Advanced ColdFusion Programmer
~|
Logware (www.logware.us): a new and convenient
Hi,
We are conducting a survey to get feedback on the new features in
ColdFusion MX 7. We would appreciate if you could spare a few moments
and complete the survey
http://www.surveymonkey.com/s.asp?u=451701362888
Thanks,
Ram Kulkarni
Macromedia Server Development
Something like
reReplaceNoCase( \b(and)\b, string, strong\1\\strong, all )
Not sure if its in the right order though, don't have time to check.
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
Does Macromedia certify the various JVMs with JRun/ColdFusion?
For example, has Macromedia certify Sun's 1.5 JVM?
Thanks,
Troy
--
Troy Simpson
Applications Analyst/Programmer, OCPDBA, MCSE, SCSA
North Carolina State University Libraries
Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855
How do I do a sort on records that already have been searched and are
displayed?
I have a button that's called ascend and when clicked I want it to sort the
selected records displayed but it sorts and displays the entire record count.
For example on the search on lname it finds 7 records. In
I'd take a look at this:
http://www.activewidgets.com/
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005
Victor,
Don't give up too soon :) Make sure and test the obvious - like is the URL
resolvable on the server (not on your local machine - but the server
it'self.
-Mark
-Original Message-
From: Victor Moore [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 6:40 PM
To: CF-Talk
do you just need to make sure that form.lname is still available for the
second select?
if that is the case then maybe the answer would be to have the display
logic and the select as part of the cfm page in someway.
for example
cfparam name=form.lname default=
cfif
1.5 is supported under the latest JRun updater, but CF is not. Note
that the last time I looked at this, can't use a JVM 1.4.2_05 with
CF.
http://www.macromedia.com/support/documentation/en/jrun/4/releasenotes_4_updater6.html#resolved
DK
On 9/23/05, Troy Simpson [EMAIL PROTECTED] wrote:
Does
I started down a similar path for a client. What I ended up doing, instead,
was to write the order forms and processing code in CF and then I converted
the final order confirmation page to ASP.net and passed all form values to
that for submission to the Cybersource site. My boss knows .NET, so he
I'm trying to locate the updater for CF Studio 5. I've started using CF MX
6.1 both at home and here at work but all I can find for updaters is MX 7.
Anyone got the URL for the link to the 6.0/6.1 updater(s)? Thanks.
--
//SIGNED//
Chris Montgomery, Contractor
HQ AF Security Forces Center,
Well I'm trying, but I run out of ideas.
Yes, the url is resolvable from the server and displays the wsdl.
I was wondering if there is anyway to see the SOAP header generated by
cfinvoke? If I could see it then maybe I can see something ..but as I said
it's a pretty basic service. The customer
Quinn,
I waited before responding hoping someone may offer a solution.
Unfortunately as far as I know, there aren't any JDBC drivers that
will convert a PL/SQL table to a ColdFusion array.
Your best option may be to return a ref cursor with two columns (index
value) and write a function to
And now they've redone it to Cybersource... I looked over the docs not so
long ago and I don't think I have ever seen a more complex payment gateway
interface, ever.
I just got done integrating my cf_ezcart with Cybersource. This was
the worst interface I've worked with out of any so far. UGH
--
Yes - there's a command line tool that comes with the server that will allow
you to see the headers and the SOAP packets. It's called TCP Monitor. You
can run it and view the raw SOAP request/response exchange.
Here's a technote:
Why not http://www.hostip.info/ ?
It's free, has an API, or you can download the entire database and
play with it yourself?
On 9/23/05, Paul Hastings [EMAIL PROTECTED] wrote:
Nomad wrote:
I am looking for something free (if available).
for country level maybe this:
Anyone know of a tag that allows ecommerce for accepting checks, rather than
credit cards?
I know cc is best, but this is a client based request. Thanks everyone.
~|
Logware (www.logware.us): a new and convenient web-based time
On 9/23/05, Douglas Knudsen [EMAIL PROTECTED] wrote:
1.5 is supported under the latest JRun updater, but CF is not. Note
that the last time I looked at this, can't use a JVM 1.4.2_05 with
CF.
http://www.macromedia.com/support/documentation/en/jrun/4/releasenotes_4_updater6.html#resolved
Please read my problem below - which I had posted a
couple of days ago.
I am basically trying to get a REF CURSOR as an output
from the stored procedure in my CF code.
I continue to face this problem i.e get error
PLS-00306: wrong number or types of arguments in
call to 'GET_METADATA' ORA-06550:
On 9/23/05, Quinn Ng [EMAIL PROTECTED] wrote:
Please read my problem below - which I had posted a
couple of days ago.
I am basically trying to get a REF CURSOR as an output
from the stored procedure in my CF code.
I continue to face this problem i.e get error
PLS-00306: wrong number or
A CFQUERY can have multiple SQL statements in it and the timeout is applied to
each statement. The timeout is passed to the DB and is the DB's issue, not CFs
issue. This means that if the driver for the DB does not support timeouts being
passed, the timeout attribute is pointless.
I'm still
Dave,
Curious if you trie granting SYS.ALL_ARGUMENTS to the schema owner?
-Adam
On 9/23/05, Dave Carabetta [EMAIL PROTECTED] wrote:
On 9/23/05, Quinn Ng [EMAIL PROTECTED] wrote:
Please read my problem below - which I had posted a
couple of days ago.
I am basically trying to get a REF
The upgrade to CFMX 7 (from 6.1) deleted everything in CF Admin including all
the datasources. Copying most of the xml files from the 6.1 version from the
lib directory to same location in the 7 version appeared to return all the
settings, but none of the datasources worked and resubmitting
Hello,
My company is looking for some form of hit tracking service - something
that would allow us to tag pages with an identifier and then consult
reports of visits, visitors, etc by tag. Basically something like those
annoying hit counters, but more professionally done and with the ability
to
On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
Dave,
Curious if you trie granting SYS.ALL_ARGUMENTS to the schema owner?
What does that grant do exactly? I'll have my DBA temporarily grant it
to see if it makes a difference, but I don't know what the above
allows?
Regards,
Dave.
Thanks for replying Dave.
It seems to be a very big bug - of not being able to use oracle ref cursors
with coldfusion ! Big for me beacuse I cannot imagine how data driven
applications can then be developed on coldfusion
Could you tell me how do I replace the version 3.3/3.4 DataDirect driver -
Once I did that it worked fine.
Ok, now you just have to buy the tag ! ;-)
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with
I've had to use the hitbox service, and the clients were pretty happy
with the simplicity of the code and the resulting reports.
On 9/23/05, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote:
Hello,
My company is looking for some form of hit tracking service - something
that would allow us to tag
2005/9/23, RADEMAKERS Tanguy [EMAIL PROTECTED]:
My company is looking for some form of hit tracking service - something
that would allow us to tag pages with an identifier and then consult
reports of visits, visitors, etc by tag.
Hi,
take a look at Clicktrack, thay also offer it as a hosted
On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
Thanks for replying Dave.
It seems to be a very big bug - of not being able to use oracle ref cursors
with coldfusion ! Big for me beacuse I cannot imagine how data driven
applications can then be developed on coldfusion
Well it's hard to hold
1.5 is supported under the latest JRun updater, but CF is not.
ROL, Java is supposed to makes applications machine undependant, but
in fact they are more than machine dependant, they are VERSION
dependant. ;-)
--
___
REUSE CODE! Use custom tags;
See
is there a way to see page load times when one doesn't have the ability
to turn on debugging or any access to the cfadmin? some kind of tag or
maybe some java?
Ray
~|
Logware (www.logware.us): a new and convenient web-based
What does that grant do exactly?
On a traditonal locked-down database, a number of the more common
roles are revoked from the schema owner. One of these roles permits
select on SYS.ALL_ARGUMENTS. If the schema owner does not have this
grant, it cannot read the spec of a procedure properly. Which
I was testing out insert triggers using DataDirect 3.4 drivers in CFMX
6.1 and noticed the problem mentioned below where the JRun CPU usage
spikes to 99% and never goes down until the service is bounced.
Removing the insert trigger makes the problem go away. Does anyone
know a good solution for
We are conducting a survey to get feedback on the new features in
ColdFusion MX 7.
The first question:
Which new features in ColdFusion MX 7 have you used so far?
is abusively mandatory.
In making answer to this question mandatory, you discart people who did
not use
any of the new features
Could you tell me how do I replace the version 3.3/3.4
DataDirect driver - with the 3.5 version that works?
I mean is there some path/procedure to follow to be able to
replace this properly and ask ColdFusion to use the new
version instead?
Technically, it's easy to use any external JDBC
We are conducting a survey to get feedback on the new
features in ColdFusion MX 7.
The first question:
Which new features in ColdFusion MX 7 have you used so far?
is abusively mandatory.
In making answer to this question mandatory, you discart
people who did not use any of the new
Hi Albert,
Their output seems to be more focused on people as opposed to pages - something
a marketing person would want to see. What i'm missing here is the ability to
track a page or group of pages and see traffic/hit stats for those pages.
Think... executive toy...
/t
Hi,
take a look at
Yes, but the very next question asks which ones are you planning on using.
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday,
I've had to use the hitbox service, and the clients were pretty happy
with the simplicity of the code and the resulting reports.
Jerry,
Thanks for the info. I signed up for their online demo and it looks pretty
basic - i'm looking for something more.. executive. Think lots of pretty graphs
and
On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
What does that grant do exactly?
On a traditonal locked-down database, a number of the more common
roles are revoked from the schema owner. One of these roles permits
select on SYS.ALL_ARGUMENTS. If the schema owner does not have this
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 11:56 AM
To: CF-Talk
Subject: Re: ColdFusion MX 7 : New Features Survey
We are conducting a survey to get feedback on the new features in
ColdFusion MX 7.
The first question:
On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
Thanks for replying Dave.
It seems to be a very big bug - of not being able to use oracle ref cursors
with coldfusion ! Big for me beacuse I cannot imagine how data driven
applications can then be developed on coldfusion
Could you tell me how do
Dimo Michailov wrote:
Why not http://www.hostip.info/ ?
It's free, has an API, or you can download the entire database and
play with it yourself?
nigel's java stuff is just plain faster (the country-ip range db is in
the jar). and you can also play w/the source if you care too. and of
I'm using the CF developer edition on internal web server and I'd like to map
another drive. Does anyone know the xml file and location to do this?
Basically, I have an external drive with 250 meg of comics that I'd like to
provide to a publisher to look through. Mapping the internal webserver
Dave Carabetta wrote:
As for the 1.5 JVM, I believe it was the Axis engine specifically that
had problems. There was a switch (search the archives) you could add
also cfreport has issues (font rendering gets blown up). and maybe flash
forms as well.
If you haven't used the new features, what sort of useful feedback
can you
provide about the new features?
As I said, if none of the new features is useful, this is an information
a survey should take in account.
If you prevent people for who nothing is useful to answer, your survey
is
DeepMetrix has all the eye candy anyone could need... it's exactly what you
want.
Kevin
-Original Message-
From: Tanguy Rademakers [mailto:[EMAIL PROTECTED]
Sent: September 23, 2005 10:08 AM
To: CF-Talk
Subject: Re: OT: hit tracking service
I've had to use the hitbox service, and the
Yes, but the very next question asks which ones are you planning on
using.
Correct, but if you do not check at least one of the options in the
first question, you're not allowed
to go to next step.
--
___
REUSE CODE! Use custom tags;
See
On 9/23/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
I'm using the CF developer edition on internal web server and I'd like to map
another drive. Does anyone know the xml file and location to do this?
Basically, I have an external drive with 250 meg of comics that I'd like to
provide to a
On 9/23/05, Paul Hastings [EMAIL PROTECTED] wrote:
Dave Carabetta wrote:
As for the 1.5 JVM, I believe it was the Axis engine specifically that
had problems. There was a switch (search the archives) you could add
also cfreport has issues (font rendering gets blown up). and maybe flash
cfsetting showdebugoutput=Yes enablecfoutputonly=NO
but I doubt it will work on a shared box. This isn't much but its what I
use for a quick/dirty idea:
On line 1 of application.cfm:
cfset request.starttime=gettickcount()
and maybe on the end of OnRequestEnd.cfm if appropriate:
cfoutput
p
!-- At top of page... --
cfset tcPreLoad = gettickcount()/
!-- At bottom of page... --
cfset tcPostLoad = gettickcount()/
cfoutput#tcPostLoad-tcPreLoad#/cfoutputms
Cheers,
Kevin
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: September 23, 2005 9:46 AM
To:
On 9/23/05, Dave Watts [EMAIL PROTECTED] wrote:
If you haven't used the new features, what sort of useful feedback can you
provide about the new features?
That the new features were not found to be useful by X%, thereby begging
other questions.
I'm not saying anything about CF7, only about
My company is looking for some form of hit tracking service - something
that would allow us to tag pages with an identifier and then consult
reports of visits, visitors, etc by tag.
I just developed something similar for a customer. Me too I find
ridiculous information like
Dave Carabetta wrote:
Ah, right, I remember you bringing this up previously Paul. Good catch.
actually that was dean who figured out 1.5 was the culprit when my
reports started looking like i was on LSD.
~|
Find out how
If you want to write something generic for one or two of my clients I may
have a job for you. I have some clients using my CMS for signup stuff that
needs this, and one of them is a BofA customer. Let me know off-list if
you're interested.
Cheers,
--
--mattRobertson--
Janitor, MSB Web Systems
Does anyone know if the com.macromedia.rssu.Parser component is included in
CFMX 7? If not, and I don't have DRK 4, how do I get it?
Thank you.
Johnny
~|
Find out how CFTicket can increase your company's customer support
Now that weâve moved to CF7 we are reworking our authentication system and
taking advantage of application.cfc. We have written a cflogin block into the
onRequestStart function but it does not seem to be setting the user. Here is
the code block we have boiled it down to for testing.
I don't know about that parser, but I've used this one:
http://mxblogspace.journurl.com/users/admin/index.cfm?mode=articleentry=8874
from Roger Benningfield. It works really well.
cheers,
barneyb
On 9/23/05, Johnny Le [EMAIL PROTECTED] wrote:
Does anyone know if the com.macromedia.rssu.Parser
I am using the default driver (i.e data direct driver) for Oracle 9i - which is
not a new version
I get problems with REF cursor with it too.
Hence dont know how would the upgrade to recent Oracle driver help anyways.
?
On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
Thanks for replying Dave.
The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1 to
hang when certain insert triggers are executed. I reverted to the 3.3
drivers, but those have other problems with them. I just installed the
Microsoft JDBC sp3 driver in hopes that it is better, and I am
wondering if anybody
We just attempted to upgrade a box from MX6.0 with the 6.1 updater. The
updater seemed to run fine and completed it job, theoretically. But now the
box will not server up any CFM pages. When attempting to retrieve a CFM page,
all we get is a blank page in the browser. HTML pages serve up
On 9/23/05, Ian Skinner [EMAIL PROTECTED] wrote:
We just attempted to upgrade a box from MX6.0 with the 6.1 updater. The
updater seemed to run fine and completed it job, theoretically. But now the
box will not server up any CFM pages. When attempting to retrieve a CFM
page, all we get is
Kugh,
You have a different issue then. CF works fine with everything prior
to Oracle 10g r2.
-Adam
On 9/23/05, kugh ng [EMAIL PROTECTED] wrote:
I am using the default driver (i.e data direct driver) for Oracle 9i - which
is not a new version
I get problems with REF cursor with it too.
I agree its written in such a way as to provide skewed results.
This is going OT (please CF_comunity paranoids abstain...;-), but I
remember a survey I had to compile
when I was working in the Computer Center at university.
The survey was made over a prison community, and one question was
We found the following in the wsconfig.log file:
jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
filter JRun Connector Filter for web site All (0)
at
jrunx.connectorinstaller.IISInstaller.installConnector(IISInstaller.java
:157)
at
How do I search a string for the first space between characters?
This should be so easy converted to This should
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
This morning, I made a comment to the effect of That may be the oddest
thing I hear all day.
And then this comes up...
Matt Osbun
Applications Manager
Health Systems, International
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005
So yeah, you need to re-run wsconfig.
-Ada,
On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
We found the following in the wsconfig.log file:
jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
filter JRun Connector Filter for web site All (0)
at
Don't you mean converted to This? left(string, find( , string) -
1) should do it.
cheers,
barneyb
On 9/23/05, Aldon Moore [EMAIL PROTECTED] wrote:
How do I search a string for the first space between characters?
This should be so easy converted to This should
--
Barney Boisvert
[EMAIL
Could you tell me how do I replace the version 3.3/3.4
DataDirect driver - with the 3.5 version that works?
I mean is there some path/procedure to follow to be able to
replace this properly and ask ColdFusion to use the new
version instead?
Technically, it's easy to use any external JDBC
On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
We found the following in the wsconfig.log file:
jrunx.connectorinstaller.ConnectorInstallerException: Error creating IIS
filter JRun Connector Filter for web site All (0)
at
The string is dynamic so the value changes!
-Original Message-
From: Aldon Moore [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:16 PM
To: CF-Talk
Subject: String Search
How do I search a string for the first space between characters?
This should be so easy converted
Do you know that masturbation is not bad?
I'm not touching that one.
-Adam
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
The DataDirect 3.4 drivers for SQL Server 2000 are causing CFMX 6.1
to
hang when certain insert triggers are executed. I reverted to the 3.3
drivers, but those have other problems with them. I just installed
the
Microsoft JDBC sp3 driver in hopes that it is better, and I am
wondering if
I am. tee-hee.
On 9/23/05, Adrocknaphobia [EMAIL PROTECTED] wrote:
Do you know that masturbation is not bad?
I'm not touching that one.
-Adam
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 100 invites.
I know this one must be easy, but I'm not a guru w/SQL yet.
How do I construct an SQL query that will list all records that have an
identical field?
For example, listing all records that contain an identical number in the
serialnumber column.
I did:
Select distinct serialnumber from
SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP BY serialnumber
HAVING rowCount 1
That should give you a list of serials that exist more than once,
along with how many instances there are. And update your AVG, it says
it's out of date.
cheers,
barneyb
On 9/23/05, Orlini, Robert
You said you needed to find the first instance of a space in a string, but
your example showed finding the 3rd instance of a string.
Which is it?
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original
NICE!
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 1:16 PM
To: CF-Talk
Subject: Re: ColdFusion MX 7 :
Select A.serialnumber from table1 as A, table1 as B
Where A.serialnumber = B.serialnumber and A.Id b.Id
Order by serialnumber, Id
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
-Original Message-
From: Orlini, Robert [mailto:[EMAIL
Thanks Barney.
It says Incorrect syntax near the keyword rowcount
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:27 PM
To: CF-Talk
Subject: Re: find identical records
SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP
Thanks Matt.
This gives an ambiguous column name error
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:31 PM
To: CF-Talk
Subject: RE: find identical records
Select A.serialnumber from table1 as A, table1 as B
Where A.serialnumber =
What DB are you using? Perhaps that's a reserved word, and needs to
be escaped/changed?
cheers,
barneyb
On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
Thanks Barney.
It says Incorrect syntax near the keyword rowcount
-Original Message-
From: Barney Boisvert [mailto:[EMAIL
Sorry -
Order by A.serialnumber, A.Id
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: RE: find identical
Thanks Kevin and Matt. I think I'll give Kevin's a try and see where it gets
me.
!-- At top of page... --
cfset tcPreLoad = gettickcount()/
!-- At bottom of page... --
cfset tcPostLoad = gettickcount()/
cfoutput#tcPostLoad-tcPreLoad#/cfoutputms
Cheers,
Kevin
-Original Message-
We installed CFMX 7 to our development box on Monday. (It's a Solaris
8 machine with a previous install of cf 6.1 and Verity.) We have been
working ever since to get Verity working and we are about to hit our
deadline. We have installed every language pack we can find and we are
still having
On 9/23/05, Barney Boisvert [EMAIL PROTECTED] wrote:
What DB are you using? Perhaps that's a reserved word, and needs to
be escaped/changed?
In Oracle, you'd do:
SELECT serialnumber, count(*) AS rowCount
FROM inventory
GROUP BY serialnumber
HAVING COUNT(*) 1
Oracle doesn't like the
We have not tried to run the wsconfig.exe file several times. It seems
to hang on starting and or stopping web services.
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 11:09 AM
To: CF-Talk
Subject: Re: Updated MX6 to 6.1 and the world
Using SQL
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: Re: find identical records
What DB are you using? Perhaps that's a reserved word, and needs to
be escaped/changed?
cheers,
barneyb
On 9/23/05,
Meaning.. MySQL? MS SQL Server? Oracle? PostgreSQL? Something else?
On 9/23/05, Orlini, Robert [EMAIL PROTECTED] wrote:
Using SQL
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:39 PM
To: CF-Talk
Subject: Re: find
In MSSQL , ROWCOUNT is a Setting for Operations Against Remote Tables
Try this:
SELECT serialnumber, count(*)
FROM inventory
GROUP BY serialnumber
HAVING count(*) 1
-Original Message-
From: Orlini, Robert [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 2:54 PM
To:
OK then I am back to where I started.
What do I need to do to solve this problem? I have been struggling with this
for some days now. SO someone please let me know what I need to do here
I get error PLS-00306: wrong number or types of arguments in call to
'GET_METADATA' ORA-06550: line 1,
I think Aldon wants to return everything before the second space, correct?
So just two words with a space between them?
Maybe something like this - looping over the string and flagging occurences
of a space, then taking the left characters when the second space is
discovered. Kinda bulky but
On 9/23/05, Ken Ketsdever [EMAIL PROTECTED] wrote:
We have not tried to run the wsconfig.exe file several times. It seems
to hang on starting and or stopping web services.
I assume you mean you *have* tried it? If so, have you re-booted the
box just to clean shut down and restart the
1 - 100 of 129 matches
Mail list logo
