transact(ms sql) VS PL SQL(Oracle)

2002-06-11 Thread Amanda Stern
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

Distinct Query help

2002-05-29 Thread Amanda Stern
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

SQL help - getting first rec of field????

2002-04-09 Thread Amanda Stern
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 +

RE: SQL help - getting first rec of field????

2002-04-09 Thread Amanda Stern
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

MS SQL logon help!!! PLEASE!!!!!!!

2002-03-26 Thread Amanda Stern
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

quick SQL question for my add/edit page

2002-03-07 Thread Amanda Stern
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

Writing Reports - Query vs StoredProc

2002-02-24 Thread Amanda Stern
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

Re: Writing Reports - Query vs StoredProc

2002-02-24 Thread Amanda Stern
. 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

CF Developer available in DFW

2002-02-23 Thread Amanda Stern
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

Network Admin position - NYC

2002-01-28 Thread Amanda Stern
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

RE: twoselectesrelated frustration!!!!! please help

2002-01-07 Thread Amanda Stern
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

cf_twoselectesrelated help!!!!

2002-01-04 Thread Amanda Stern
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

RE: Simple FORM Variable ERROR?????

2002-01-04 Thread Amanda Stern
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

Simple FORM Variable ERROR?????

2002-01-03 Thread Amanda Stern
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

Sys Admin needed in NY area

2001-09-25 Thread Amanda Stern
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,

simple array help - newbie

2001-09-07 Thread Amanda Stern
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

heading on every page?

2001-09-07 Thread Amanda Stern
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.

SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Amanda Stern
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

SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Amanda Stern
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

Cf in Select Stmt help

2001-08-21 Thread Amanda Stern
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

Re: cf in select stmt help -Works - THANKS

2001-08-21 Thread Amanda Stern
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

ahh....help with rpt grouping troubles

2001-08-16 Thread Amanda Stern
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

Re: NY Fast Track to Cold Fusion Classes???

2001-08-16 Thread Amanda Stern
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

legal question?????

2001-08-09 Thread Amanda Stern
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

Time Difference Function - newbie!!!!!

2001-08-09 Thread Amanda Stern
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,

Cold Fusion Developer - beginner

2001-08-06 Thread Amanda Stern
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