Does anyone have a good article or experiences on the
differences between ms sql and oracle databases...
thanks,
--- phumes1 [EMAIL PROTECTED] wrote:
I don't know whats happening...
The contents of my output.txt file still contains
the following. The output
to the screen (console) is
Hello,
I am having a little trouble constructing this query
because I need a count of a distinct composite
column combo - Date and CMid..for example..here is
the table and the columns in it:
DateCMid value rate
- -- -- --
02/021 3 6
02/021
Hello,
I have been trying to figure out how to write this SQL
stmt..I have it written but it needs one more
modificationI need the query to only pull the
first unique EventID...
SELECT CMME.iMonthlyEventId as EventID,
CMME.iCMApptId as CMapptID,
cli.vClientFName +
though...
--- Kevin Schmidt [EMAIL PROTECTED] wrote:
SELECT DISTINCT(CMME.iMonthlyEventID)
:)
Kevin
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:18 AM
To: CF-Talk
Subject: SQL help - getting first rec of field
Hello
Sorry for thowing in this MS SQL questions but its an
emergency!! My Sys Admin rebooted the server this
morning and now I cannot get acces to MS SQL. When I
try to start the services, it gives me a 1069 logon
failure errordoes anyone know how I can fix
this..I am assuming I need to reset a
Hello,
I need to add a new hidden field to my add/edit page
that will update the table when a new record it added
or updated..not sure how to write the SQL stmt to
automatically create this hidden field.
The user is required to enter a 6 digit program code,
which begins with a letter followed
Hello,
The application I am working on has about 10 reports
that are being run every month. The queries for these
reports are written in the CFML page using CFQUERY.
I was wondering if it would be better(execution
timewise) to write a stored procedure on the MS SQL
side and calling it in the
.
HTH
Clint
-- Original Message
--
from: Amanda Stern [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Sun, 24 Feb 2002 14:41:10 -0800 (PST)
Hello,
The application I am working on has about 10 reports
that are being run every month
Hello,
I am looking for a CF Developer position(Beginner to
intermediate) in the Dallas Fort Worth area.
Please email me offline if you would like me to send
you a copy of my resume.
TIA!
__
Do You Yahoo!?
Yahoo! Sports - Coverage of the
Hello,
We have an immediate need for a newtork admin...below
is a description of the position...please email me
your resumes if you are interested or if you have any
further questions..
Thanks,
---
In this position, the Manager Information Technology
will be
even be
this.form.submit();? Are you
submitting to the same form? It seems like you're
calling the query once
for the selectsrelated tag, submitting the form to
itself but the query i
s
not called again.
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent
is the Force, and a powerful ally it is. -
Yoda
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 2:25 PM
To: CF-Talk
Subject: Simple FORM Variable ERROR?
Hello,
I am trying to create a simple form that depending
of my sites that I can send to you if you'd
like.
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 12:25 PM
To: CF-Talk
Hello,
I am trying to create a simple form that depending on
which item is selected in one dropdown will determine
the contents of the next dropdown fieldit doesnt
to recognize my form variable though
here is my code:
td width=300
*Outreach Method:br
select
Hello,
I work for a small Non-Profit organization in New York
City. We are currently looking for a Sys Admin. We
have an NT platform and run a CF application and MS
SQL Server 2000.
Please email me at [EMAIL PROTECTED] if you are
interested in finding out more info.
Thanks,
Hello,
I am trying to build an array and cannot get around
this error message:
The element at position 2 in dimension
1 of object aggdata.AggHours cannot be found. The
object has elements in positions 1 through 1. Please,
modify the index expression.
This is my code for
Hello,
I have a CF report that is about 15 pages long.how
do I get the headings to print on every page?
Thanks again!
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
hello, I've been working on this query for a while and
cant get it to work the way I need it to, i am close
though.here is the problem - the cas table is
keyed by [iCasacApptID], the cats table has a
composite key of [iCasacApptID, cTreatSelectID]. So
when I output the results if
hello, I've been working on this query for a while and
cant get it to work the way I need it to, i am close
though.here is the problem - the cas table is
keyed by [iCasacApptID], the cats table has a
composite key of [iCasacApptID, cTreatSelectID]. So
when I output the results if
Hello,
I am trying to get this query to work and not sure
how...anyone have any ideas? The problem is in the
joining of the cas table and the cats tablethere
is a 0 to many relationship between these
tablesie[cas.iCasacApptID = cats.iCasacApptID]
many never equal each other because
Thank you!!
That did the trick.
--- Deanna Schneider [EMAIL PROTECTED]
wrote:
Whew! This is an interesting query, Amanda.
There are a couple of issues here. Your loop should
be outside the query,
otherwise what you'll end up with is multiple select
statements within the
query. My
Hello,
I am having trouble fixing this report and I am quite
new to CFgetting a bit frustrated...
my report should look something like this:
(the problem is that the numbers for Recipient are in
the Neither column and the numbers for the Neither are
in the Recipient column. Applicant is
www.winmill.com
--- Joshua Miller [EMAIL PROTECTED] wrote:
Anyone know of a reputable organization in the NY
area that we could send
some developers to for FastTrack and possibly
Advanced CF and SQL training?
Thanks!
Joshua Miller
Web Development - Eagle Technologies Group
Business
Hello,
Not sure if anyone can answer this question/concern
for me but will ask anyways.I have been creating
some reports for HR that will be used internally to
keep track of our employees work(ie number of items
completed, average numbers etc). One of the averages
I am being asked to
Hello again!
I am having some trouble calculating the time
difference for two datetime field2 which I then try
and add togetherhere is what I have done:
My SQL Stmt:
Select DateDiff(mi, dApptEndTime,
dApptBeginTime) as Diff1,
DateDiff(mi, dApptEndTime2,
Hello,
Does anyone know of any open Cold Fusion positions
available in the Austin TX or Houston TX area
requiring about 1 year of experience?
Thanks!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
26 matches
Mail list logo