Install of cfServer 5 not working

2002-08-19 Thread Paul Ihrig
ok so i go to a clients to set up a local host version of there site on one of there machines install pws, mdac & then cf server 5, single ip version Win98 now the server shows as running i can browse local htm docs but it will not render any cfm pages. the cfm's are not even hitting a data

cf server Win98 pws problem

2002-08-16 Thread Paul Ihrig
ok so i go to a clients to set up a local host version of there site on one of there machines instal pws, mdac & then cf server 5, single ip version now the server shows as running i can browse ant local htm docs but it will not render any cfm pages. the cfm's srent even hitting a datasource

RE: Order By Problem

2002-08-15 Thread Paul Ihrig
right i tried SELECT Artists.SurveyID, ArtistCOMMENTS, surveys.[Self-Review] AS Self FROM Artists, surveys WHERE Artists.SurveyID IN (#qrySelfServ.SurveyID#, #qryPrinServ.SurveyID#, #qryServ.SurveyID#) AND surveys.RevieweeID = #FORM.RevieweeID# ORDER BY surveys.[Self-Review] but the output l

Order By Problem

2002-08-15 Thread Paul Ihrig
ok below i commented what im trying to do. basically make the output dispaly in the order i want. but it is seems to be reordering itself... any help would be great. look below. thanks. -paul SELECT SurveyID, surveys.[Self-Review] AS Self FROM surveys WHERE surveys.RevieweeID = #FORM.Review

RE: flash or fireworks for this?

2002-07-18 Thread Paul Ihrig
thx.. my trial of flash ran out. wait for or budget people to get me a lic.. this thing is due today.. so looks like fireworks & dw. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion a

flash or fireworks for this?

2002-07-18 Thread Paul Ihrig
hey guys.. i need to build a real quick presentation of images. i need it to be able to play like a slide show. but allow the user to stop it goto next & previous images. what is the quickest way to do this? im a bit rusty on both apps. what widgets are available? thanks. -paul __

RE: breaking a loop... need help

2002-06-30 Thread Paul Ihrig
Thanks To: Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 I really do appreciate the great help i have recieved here... The code that did it! -paul SELECT D

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
still need help! thx -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.

INNER JOIN

2002-06-29 Thread Paul Ihrig
can you see whats wrong with this query? error below thanks -paul SELECT tblRelations.Relation_ID, tblService.Service_ID, tblService.Service, tblEmployee.EmployeeID, LEFT(LTRIM(tblEmployee.LastName),1) + '.' + LEFT(LTRIM(tbl

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
this is as close as i can get... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid07.cfm not quiet there.. i know it has to be something relatively simple! any more help would be fantastic! -paul SELECT EmployeeID, LastName, FirstName FROM tblEmployee ORDER BY LastName; SELECT Re

RE: Help Displaying results that loop

2002-06-29 Thread Paul Ihrig
ok came into the office to try it out... mucked about a bit... and wasn't able to float it... Isaac you can see a your modified example here... http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid06.cfm im going home now.. bringing my laptop to hopefully get this working this weekend.. t

RE: breaking a loop... need help

2002-06-29 Thread Paul Ihrig
Bud --- i pasted your code here http://www.columbus.nbbj.com/IS/internalsupport/InteEmpGrid05.cfm at the bottom of the page... still no luck.. -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The pl

Devcon Volunteers

2002-06-25 Thread Paul Ihrig
any one know if MM has any programs for volunteers? for setting up/tearing down & such... looks like my Co. wont pay for any training or conferences.. so would like to figure out other options to get in & learn... maybe i can grow a beard by then & sneak in joke :] -paul _

RE: chart of sorts...

2002-06-24 Thread Paul Ihrig
any one? i am trying to do it off 2 queries... mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 11:53 AM To: CF-Talk Subject: chart of sorts... ok i want to create a chart if an employee has filled something out.. LIKE Employee Pat Joe LisaSue Service TriForm X

chart of sorts...

2002-06-24 Thread Paul Ihrig
ok i want to create a chart if an employee has filled something out.. LIKE Employee Pat Joe LisaSue Service TriForm X X CAD X X X DT X X But using the code below it only seems to display t

C:/CFusion to D:/CFusion Advice..

2002-06-20 Thread Paul Ihrig
OK... i messed up. i updated cf server on the C Drive. without having enough space left over for the virus scans & other things to run.. is there a way to move the C:/CFusion to D:/CFusion with out a uninstall & reinstall??? any advice or suggestions would be appreciated. you can laugh now...

Free to cheap Forum Software

2002-06-12 Thread Paul Ihrig
hello all. i know this has been discussed in the past if you have links to free or cheap forum or discussion boards i would appreciate it. thanks -paul __ Structure your ColdFusion code with Fusebox. Get the official book at h

JS Select Box Value Question :: help

2002-06-11 Thread Paul Ihrig
Hello quick question on grabbing a specific result from a select box Right Now i have this select: #NumberFormat(rs_Print_Type.Print_Type_Price, '.999')# :: #rs_Print_Type.Print_Type_Width#'/ #rs_Print_Type.Print_Type_Height#' :: #rs_Print_Type.Print_Type_

RE: JS :: Reset Specific field.

2002-06-10 Thread Paul Ihrig
got it objForm.Print_Type_ID.reset(); -paul __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofit

JS :: Reset Specific field.

2002-06-10 Thread Paul Ihrig
hello i want to be able to reset specific fields to their default values based on other fields selected i can reset all the fields in a form by doing this. but say i only want to reset Print_Type_ID i cant seem to get it to work. have tried onClick="document.Print_Type_ID.reset(); but i get

RE: JS Question

2002-06-06 Thread Paul Ihrig
ok i was able to do this... seems to work. but question for you guru's out there. isn't this kind of Bloated? shouldn't there be a way to do this with less code? thanks. -paul math function TotalNum_Origionals(obj) // "this" from below gets passed as "obj" {

RE: JS Question

2002-06-06 Thread Paul Ihrig
just paste it into a htm file - test.htm - math function TotalNum_Origionals() // "this" from below gets passed as "obj" { var total = 0; var amtNum_Origionals = parseFloat(document.all('Num_Origionals').value); var amtNum_EachSet = parseFloat(document.all('Num_EachSet').value); i

RE: JS Question

2002-06-06 Thread Paul Ihrig
that's similar to what i have in the htm file at the bottom but it doesn't do it -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetp

RE: hiermenus

2002-05-30 Thread Paul Ihrig
This is what i used. very use full for spnning frames for your nav http://www.webreference.com/dhtml/column20/ -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
this is odd if i do this ORDER BY CHARINDEX(',' + Title + ',' , '#newOrderList#'), Fullname; it basically doesnt even put in the Title as a Order By Item... so my group by in the outputs dont work.. oh well. i can fake this one.. look like a good time to use QaQ -paul ___

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]The data type int is invalid for the charindex function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary. SELECT LEFT(RTrim(tblEmployee.Lastname),10)

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
ok...Philip. how should the parameters go? i cant find any info on CHARINDEX in my books. SELECT LEFT(RTrim(tblEmployee.Lastname),10)+', '+tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.StatusID, tblEmployee.TitleID, tblSt

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
nope, didn't do it thanks Jochem -paul -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 8:25 PM To: CF-Talk Subject: Re: ORDER BY question Randell B Adkins wrote: > Create a new field called Sequence or something. > Based on the data a

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ "...'If there must be trouble, let it be in my day, that my child

RE: ORDER BY question

2002-05-29 Thread Paul Ihrig
Man! you guys went way over my head hear! : ] for this purpose since there are only 4 separate groupings i may just do 4 separate queries. not sure. thought i could do it like Order By tblJobTitle.TitleID=25, tblJobTitle.TitleID=26, tblJobTitle.TitleID=28, tblJobTitle.TitleID=4; -paul ___

RE: ORDER BY question

2002-05-28 Thread Paul Ihrig
ok. ASC & DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... Thanks -paul __ Signup for the Fu

ORDER BY question

2002-05-28 Thread Paul Ihrig
ok. ASC & DESC don't work on this one. i want to be able to ORDER BY in a specific order such as ORDER BY tblJobTitle.TitleID='25,26,28,4' is that possible? if not how else could i do it... Thanks -paul __ Get the mailserv

RE: Date Time Manipulations in Query?

2002-05-23 Thread Paul Ihrig
al Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 3:49 PM To: CF-Talk Subject: RE: Date Time Manipulations in Query? ok this is what i got to work in my select now. SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm, #Year(todayDate)# - Year

RE: Date Time Manipulations in Query?

2002-05-23 Thread Paul Ihrig
ok this is what i got to work in my select now. SELECT #Year(todayDate)# - Year(HIRE_DATE) AS YearsWithFirm, #Year(todayDate)# - Year(HIRE_DATE) + YEARS_OTHER_FIRMS AS TotalYearsExperience, But if the YEARS_OTHER_FIRMS in NULL/Blank or Zero then the alias TotalYearsExperience doesnt generate.

Date Time Manipulations in Query?

2002-05-23 Thread Paul Ihrig
ok i have this query once the results are generated i can do this, below... but i would like to be able to do the same thing in the select query. so i can do some checks in my where statements. how would i do the Years At Firm: & Total Years Experience: in a select query? hire date: #DateForma

inmajic db text works

2002-05-15 Thread Paul Ihrig
any one here use inmajic? we have version 4 i never played with it, but our librarian uses it to post articles & such i am trying to apply a style sheet to it with no success other then on the form pages, but not the results which are generated by a dbtwpub.dll so if you know what im talking

RE: COM :: CF :: Wolfenstein & Q3

2002-05-14 Thread Paul Ihrig
well i just did it using q3plug & the sets variable in my maprotate.cfg now it works fine http://www.forumplanet.com/planetwolfenstein/topic.asp?fid=1692&tid=646541 -paul __ Get the mailserver that powers this list at http://

RE: COM :: CF :: Wolfenstein & Q3

2002-05-10 Thread Paul Ihrig
well... if any one want to help me with this i would appreciate it. would give access to rcon while we work on it & Private password, so when the server fills to 22-28 you can have one of the reserved private slots! ?? : ] ?? just something goofy to play with i know the gaming community woul

RE: rds :: cf 5.0 :: localhost

2002-05-07 Thread Paul Ihrig
got it. just had to move the main dir inside the cfide dir. thanks Mike! -paul __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.c

rds :: cf 5.0 :: localhost

2002-05-07 Thread Paul Ihrig
for some reason i cant get rds to work with either localhost or 127.0.0.1 i never ran into this before. this in for my local copy of cf-server 5 & studio 5 but has been going on since i installed dwmx & cfservermx any ideas would be great -paul __

RE: output cf to html

2002-05-02 Thread Paul Ihrig
ever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 ---City2 --Adam -whatever1 -whatever2 -whatever3 --Bob -whatever1 -whatever2 -whatever3 -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]]

RE: output cf to html

2002-05-01 Thread Paul Ihrig
y child may have peace'..." - Thomas Paine, The American Crisis -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 3:18 PM To: CF-Talk Subject: RE: output cf to html thanks guys... i will try it a few differnt way that you suggest

RE: output cf to html

2002-05-01 Thread Paul Ihrig
thanks guys... i will try it a few differnt way that you suggested. Now if i could only learn how to loop over my quries with a group with QaQ?? then i think i wouldnt even need to do this right now i have like 20 incldes a hiting the same data source many, many times just to get the output

output cf to html

2002-05-01 Thread Paul Ihrig
I have this Huge Honking report written in cf it shows exactly what i want. but i don't want a user to run this report every time they hit the page. i would like to know how to have cf-server run the page... but just save it to html every night. so that it gets updated basically once a day

RE: cfinclude passing multiple params

2002-05-01 Thread Paul Ihrig
] +---+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:06 PM To: CF-Talk Subject: RE: cfinclude pas

RE: cfinclude passing multiple params

2002-05-01 Thread Paul Ihrig
nm... dough -paul -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 2:46 PM To: CF-Talk Subject: cfinclude passing multiple params ok i have an include that i want to use multiple times on a page. passing different parameters to it how can

cfinclude passing multiple params

2002-05-01 Thread Paul Ihrig
ok i have an include that i want to use multiple times on a page. passing different parameters to it how can i do this? seems like both includes just grab the last cfset?? thanks guys. -paul CMH Partners

RE: Group & Loop Help!

2002-04-30 Thread Paul Ihrig
i think im close, but it just keeps going on.. looping infinitely! i just want it to look like this Studio01 Paul A 222- Joe D 333- Jack G 232-3232 Mel B 222- Harry E 333- Merril H 232-3232 Pete C 222- Ben F 333- Sue I 232-3232 Studio02 Paul A 222- Joe D 333- Ja

Group & Loop Help!

2002-04-30 Thread Paul Ihrig
ok this is going to sound long i have a phone list [we all do!] i can group by studio & display in one column employee phone info & such or if i write it a different way i can show all office info LOOPed into 3 columns. But i cant seem to do both! I would like to use a group by studio like i ha

rds problems localhost 127.0.0.1

2002-04-26 Thread Paul Ihrig
ok this is odd i have never had this happen before for some reason i cant see my datasource under my localhost rds i have tried to delete & recreate both 127.0.0.1 & localhost have e checked the password in cfadmin no problem! i get a 404 when looking at it. any ideas? very odd. thanks -pau

RE: weird insert/update error

2002-04-17 Thread Paul Ihrig
h MAC versions and they are the same (2.6). did this help you at all?) -Craig Thomas -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:23 PM To: CF-Talk Subject: RE: weird insert/update error found the problem when i copied the files &

RE: weird insert/update error

2002-04-17 Thread Paul Ihrig
tnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:27 AM To: CF-Talk Subject: RE: weird insert/update error ok. can i do that in cf admin? -paul -Original Message-

RE: cfgraph in 5.0 ??

2002-04-16 Thread Paul Ihrig
Right Stephen I cant find any solid documentation on what i need to do to get JRun & generator to work on cfgraph. seems pretty odd. cfgraph worked right out of the box on the win2k server. no tweaking necessary but on win2k on my laptop, it isn't working. If any one knows a Quick & Dirty way o

RE: cfgraph in 5.0 ??

2002-04-16 Thread Paul Ihrig
copy of jrun and generator running...these are required by cfgraph. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 6:25 PM To: CF-Talk Subject: RE: cfgraph in 5.0 ?? still not able to use cfgraph i did install a local copy of jrun, then uninsta

RE: cfgraph in 5.0 ??

2002-04-15 Thread Paul Ihrig
conflict after another. -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 3:51 PM To: CF-Talk Subject: RE: cfgraph in 5.0 ?? Im on Win 2000 any other ideas.??? __ Your ad could

RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
omas [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 2:53 PM To: CF-Talk Subject: RE: ntConsoleJava 98% of sys resources win2k? check that the graphing server is running mycpmuter>>manage>>services and apps>>services>>CF Graphing server. -Original Message- Fro

Could not connect to JRun Connector Proxy

2002-04-15 Thread Paul Ihrig
System: Win2K 5.00.2195 Server: IIS 5 CF ENT 5 i have uninstalled & reinstalled the cfgraph from the cd 3 times now. i cant get Service: ColdFusion Graphing Server to stay up for more then a second. i have read every thing i can find on MM's site. i have read all the docs i can on the issue. i

RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
just re-checked CF Management repository inst running neither is cf graphing services. i tried to start them both. they wont! -paul -Original Message- is the ColdFusion Graphing Server running? are the CF OEM versions of Jrun and Generator installed ? CT __

RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
l Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:57 PM To: CF-Talk Subject: RE: ntConsoleJava 98% of sys resources is the ColdFusion Graphing Server running? are the CF OEM versions of Jrun and Generator installed ? CT -Original Message----- From: P

RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
i have done this hot fix http://www.macromedia.com/v1/Handlers/index.cfm?ID=22280&Method=Full but still no luck on getting cfgraph to work -paul -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 12:31 PM To: CF-Talk Subject

RE: ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
It's the cut down jrun that's used for a few things including cfgraph support, un-install cfgraph and see if it's still doing it. You can always try installing it again later if t is, sometimes works. -----Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Mo

ntConsoleJava 98% of sys resources

2002-04-15 Thread Paul Ihrig
hey guys my laptop is crapping out running win2k is ntConsoleJava a part of cf 5 C:\CFUSION\jre\bin it is taking up way to much resources. if not what is it a part of? thanks -paul __ Your ad could be here. Monies from ads go

RE: cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
Im on Win 2000 any other ideas.??? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldf

RE: cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
: Thursday, April 11, 2002 10:29 AM To: CF-Talk Subject: Re: cfgraph in 5.0 ?? What OS are you running it on? It won't run under Win98. - Original Message - From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 11,

RE: cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
Talk Subject: RE: cfgraph in 5.0 ?? Did you install the support for cfgraph when you installed CF5? -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 8:48 AM To: CF-Talk Subject: RE: cfgraph in 5.0 ?? i am trying the examples in the 5.0 WACK book

RE: cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
i am trying the examples in the 5.0 WACK book also tried the example under C:\CFUSION\Generator\Test_CFGraphTag.cfm -paul -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 9:41 AM To: CF-Talk Subject: RE: cfgraph in 5.0 ?? weird. when i

RE: cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
don't have the flash plugin, it could appear to just "hang". That's what happened here with some of our manager's pc's...You could just specify .jpeg as the output format to check for sure. - Gary -----Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Se

cfgraph in 5.0 ??

2002-04-11 Thread Paul Ihrig
ok, this should be pretty simple but no matter what i do i cant get this silly thing to work. just hangs. is there any thing i need to do? thanks -paul __ Signup for the Fusion Authority news alert and keep up with the latest n

CSS text for disabled form items

2002-04-10 Thread Paul Ihrig
hello all just curious if any one knew how to modify the color of text, in From items that have been disabled. as a default the text color is gray. i want it to stay its normally defined color. any suggestions would be great. thank you -paul } 1 { background-color: #008000;font-size:1

504 Gateway Time-Out

2002-04-09 Thread Paul Ihrig
Ok so i have this little app i upload it through our VPN to our web server on the other coast now when i try to do an insert or an update i get a time out any ideas what i can do to fix this. i know it can be a million & one things. i just don't want there server admin, before i know if there is

RE: Date Problems Again :: Yet Another one

2002-04-09 Thread Paul Ihrig
et.nz/ http://www.cabbagetree.co.nz/ */ -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 9 April 2002 9:02 a.m. To: CF-Talk Subject: Date Problems Again :: Yet Another one Yet Another Problem i am trying to group by Month/Year i just cant seem to get it. i have

RE: Better way? Loop, Sql help

2002-04-09 Thread Paul Ihrig
Dave Thank You! I do appreciate the help one thing i had to change was adding () around the IN date SELECT tblKid.StudioID, tblKid.KidDate FROM tblKid WHERE Month(tblKid.KidDate) IN ('#Month(todayDate)#') Thanks Again -paul -Original Message- From: Dave Carabetta [mailto:[EMAIL PROT

Better way? Loop, Sql help

2002-04-09 Thread Paul Ihrig
ok i am trying to get this down & am running into problems Any Help would be greatly appreciated. First in rsStudioIN.StudioID i am trying to generate a list of id's that where created this month it seems to being working, but when i call rsStudioIN.StudioID in my next Query, it only takes the fi

Date Problems Again :: Yet Another one

2002-04-08 Thread Paul Ihrig
Yet Another Problem i am trying to group by Month/Year i just cant seem to get it. i have read ever thing i can find in WACK on group, GROUP BY, & CreateODBCDate to no avail. I have tried but that does nothing good. in this query. i want it to show my dates entered but on duplicates of the da

RE: Date Problems Again

2002-04-08 Thread Paul Ihrig
ioName, tblKid.StudioID, tblKid.KidDate ORDER BY StudioName ASC -paul -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 3:29 PM To: CF-Talk Subject: Date Problems Again Hello What i am trying to do is a query for a select box I want to return a

Date Problems Again

2002-04-08 Thread Paul Ihrig
Hello What i am trying to do is a query for a select box I want to return all the StudioName's for this month who haven't already done a submission for this month. So if a studio has submitted this months form there name is no longer in the list, of studios who need to fill it out. But next mo

Date Range

2002-04-08 Thread Paul Ihrig
Ok 3 Questions... if you have some time. 1.] below i have a range in a select that shows Next month, Every month for a year. Bt i cant seem to show this month. i have tried -1 in the DateAdd, but that just makes the range count back wards. have also tried removing the date add. 2.] Also If i wa

List Loop threw dates. & other date questions

2002-04-05 Thread Paul Ihrig
ok just a few questions about list looping & dates this may look funky but i am sure it is simple.. for a select box if i want to loop threw a list of dynamically generated dates, only showing month & year How would i do this?? Drop Down List January 2002 February 2002 to January 2005 how wou

RE: CFREPORT error again!!! dll's grrrrrr..

2002-03-20 Thread Paul Ihrig
Hey i just wanted to say thanks to every one who replied. i just deleted the old reports. built a new one to hit the sql server and it worked out just fine. thanks again -paul __ Structure your ColdFusion code with Fusebox. Get

RE: CFREPORT error again!!! dll's grrrrrr..

2002-03-20 Thread Paul Ihrig
y are on the report. Either that or the username/password is wrong. Granted, I have not used it with CF. HTH, Tim P. - Original Message - From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:30 AM S

RE: CFREPORT error again!!! dll's grrrrrr..

2002-03-20 Thread Paul Ihrig
error. - Original Message - From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:30 AM Subject: CFREPORT error again!!! dll's grr.. > cfstudio 5 > crystal 8 > > i have it loaded on my l

CFREPORT error again!!! dll's grrrrrr..

2002-03-20 Thread Paul Ihrig
cfstudio 5 crystal 8 i have it loaded on my local machine with local server i cant get this piece of crystal to work! i have read every thing i can find. most articles said to delete this or move that dll.. but none of it seems to work for me! any ideas??? thank you! -paul ---

RE: Verity and PDF's

2002-03-19 Thread Paul Ihrig
no it is not correct it will see pdfs just fine -paul -Original Message- From: Moneymaker, Jon S CONT (WPNSTA Yorktown) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 4:10 PM To: CF-Talk Subject: Verity and PDF's I understand that the version of verity that comes with CF 4.

RE: Update multiple rows

2002-03-11 Thread Paul Ihrig
hello Thanks Steve & all that worked like a charm! i appreciate the help! -paul __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyh

RE: Update multiple rows

2002-03-11 Thread Paul Ihrig
tblPhone.EmpResID = '#FORM.EMPLOYEE_ID#' AND tblPhone.PhoneID = 'evaluate(#FORM.PhoneID# & #Emp#)' _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Paul Ihrig [mailto:[EMAIL

RE: Update multiple rows

2002-03-11 Thread Paul Ihrig
oops! my error Error Diagnostic Information ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '341,95' to a column of data type int. The error occurred while processing an element with a general identifier o

RE: Update multiple rows

2002-03-11 Thread Paul Ihrig
-paul -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:07 PM To: CF-Talk Subject: Update multiple rows ok i am trying to update multiple rows based on a form element that loops over a query can this be done? my action in the UPDATE is not

Update multiple rows

2002-03-11 Thread Paul Ihrig
ok i am trying to update multiple rows based on a form element that loops over a query can this be done? my action in the UPDATE is not working right. using sql 7. i could just do one at a time easy enough. but would like to do them together. UPDATE tblPhone SET PhoneNumb='#FORM.Phon

RE: Group in cfoutput query. brain fart

2002-03-07 Thread Paul Ihrig
Mathew & all thank you! got me back on track! thank you! what i did below. -paul SELECT tblEmployee.Lastname + ' ' + tblEmployee.Firstname as Fullname, tblEmployee.EMPLOYEE_ID, tblEmployee.EmployeeID, tblEmployee.StudioID, tblEmployee.Status, tblStudio.StudioID, tblStudio.OfficeID, tblStudi

RE: Group in cfoutput query. brain fart

2002-03-07 Thread Paul Ihrig
thanks Chuck & all but it is still not working the way i envision it. any more advice on this would be great! i know i know it, just cant get it! i have tried nesting different the Current Results: Adkins , John (241) Edit Photo Adkins , John 222-223- Edit Photo Anderson , Dorma

Group in cfoutput query. brain fart

2002-03-06 Thread Paul Ihrig
sorry for the long email my problem is that if an employee has more then 1 phone number the whole record of that employee is displayed twice i would like to have it just loop over the multiple phone numbers, of that employee & display them along side there name. i have tried writing several di

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
do i need a full version on the server to run cfreport? http://store.crystaldecisions.net/dr/v2/ec_MAIN.Entry16?SP=10024&PN=29&xid=1 5248&V1=30010453&V2=30010453&V3=1&V5=11028983&V4=10&S1=&S2=&S3=&S4=&S5=&DSP= 0&CUR=840&PGRP=0&CACHE_ID=36273 what version!?? thank you -paul _

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
:41 AM To: CF-Talk Subject: RE: CFREPORT :: (CRPE32.DLL) could not be located Don't you have to have Crystal Reports Software ($1,500 plus) installed on your server for CFREPORT to work? J -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27,

CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on

RE: auto login server & power outage

2002-02-19 Thread Paul Ihrig
elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 2:58 PM > To: CF-Talk > Subject: ot: auto lo

ot: auto login server & power outage

2002-02-19 Thread Paul Ihrig
hey guys asked this 3 years ago. got great help forgot how i did it now i need to build a new box. part of it was done in regedit before winnt...no win2k i want my server to login itself in when it boots up with out stopping at the login screen. also the regedit part was i think if the server

RE: cfinclude, who to pass for variables to?

2002-02-14 Thread Paul Ihrig
ok. but if the page changes then the form action would have to change? so i cant just say action = 'verityResults.cfm' if the verityResults.cfm is also in each seperate page? or could i just have it where thispage always posts to the current page the form is included in? -paul -Orig

cfinclude, who to pass for variables to?

2002-02-14 Thread Paul Ihrig
hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page i

cfinclude, who to pass for variables to?

2002-02-14 Thread Paul Ihrig
hello all. just curious how i would pass form to a n included page. say verity i have an cfinclude search field on the top of all my pages. i cfinclude the results page in small box on all my pages how do i pass the search info to the results page? normally i would just select the result page i

Combining 2 tables?

2002-01-17 Thread Paul Ihrig
OK i need to merge 2 employee info tables into one. problem, both tables have employeeID as primary key 1 table has 20+ CF apps based of it the other the same amount of asp apps. how do i do this gracefully. i don't mind having the CF relat

<    1   2   3   4   5   6   7   8   >