TSQL

Hi folks: This question could be innapropiate but this list has always been great . Besides I'm a newbie. My problem is Transact-SQL related. I want to convert a numeric value (it 's the amount of seconds a user has spend in one of my sites) to this format hh:mm:ss .Is there any function in SQL

Re: TSQL

Hi friends: here is the solution that is actually working. Of course each of you gave a piece of clue. thanks and I really appreciate your help. regards Mario DECLARE @DurationAux INT, @DurationStringAux varchar(255) /*here goes the code where @DurationAux takes his numeric value */

CFHTTP Bad Request

I have a problem using cfhttp in one part of my code. I'm stumped so I need your help people Here is what I receive in the browser IE. The Status Code: 400 Bad Request The Raw Header: HTTP/1.1 400 Bad Request Server: Microsoft-IIS/4.0 Date: Mon, 24 Jun 2002 20:48:50 GMT Content-Length: 407

SQL server trouble

Hi all friends: I got a coldfusion system with an SQL server . Today I came in here and I realize that I can't connect this SQL server from any other computer through ODBC . I could do that before , now none of my remotly ODBC connections are working This is the error I receive when I try to

Re: SQL server trouble

with your SQL network libraries. I actually just had this problem yesterday so if that is it I'll tell you what worked for me. Have you made any configuration changes to SQL recently? /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002

Re: SQL server trouble

tell you what worked for me. Have you made any configuration changes to SQL recently? /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 12:10 PM To: CF-Talk Subject: SQL server trouble Hi all friends: I got a coldfusion system

Re: SQL server trouble

file, (c:\winnt\system32\drivers\etc\services) if it would tell you what is hooked on that port. if it does, then you know what app is the culprit. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Mario Martinez [mailto

Re: Re[2]: Preventing user from going back

What if I view the file source, erase all the java script code that is bothering me .Save the file into my local harddisk and run the browser over it and try to going back??? . regards Mario - Original Message - From: Critz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday,

Re: SQL server trouble

changing the startup parameter for that service to manual to allow sql to get it first. Of course you then have to remember to manually start that other service after every reboot. /rob -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 2

CFHTTP question

Hi all friends: I'm using the cfhttp tag to log into a site remotly and walk around after being logged , the problem comes out when I meet a link (that I need to call trough cfhttp too) like this: a href=javascript:cf_http_hook_fullpath('http://skillport.nywired.org/_SkillS

SQL puzzle

Down here tHE First query result is 267 tHE Second query result is 211 The Thirth and four query result is empty. My question is whyy??? Thanks friends in advance and forgive my desperate state. regards Mario // First Query SELECT

Re: SQL puzzle

Philip: Your valid help has been well appreciated. I solved my problem with your suggestion Thanks a thousand friend Regards Mario - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 1:40 PM Subject: RE: SQL puzzle

How to detect timeout session??

Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time without actvity. Any easy way to detect that at the beginning of one template??? regards and thanks in advance Mario

Re: How to detect timeout session??

- From: Mario Martinez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 11:49 AM Subject: How to detect timeout session?? Hi friends: I need to find an easy way to detect timeout session to redirect the user to a login page in case he has spent too much time

restarting a service

Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any way to restart a service?? , I mean any tag, function , etc . I got coldfusion installed in a windows 2000 server. Thanks in advance for any help.

Re: restarting a service

? -Original Message- From: Mario Martinez [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:13 AM To: CF-Talk Subject: restarting a service Hi friends: This is my problem: I need to restart a service periodically. I'm aware I can easily schedule tasks in Coldfusion but ,is there any

SQL query

I need to choose a group of records from a table based in the fact that a datetime field is not null . how could I make the filtering in the where clause???. I'm using transac-SQL. Thanks in advance friends regards Mario __

Re: SQL query

thank you very much regards Mario - Original Message - From: Dina Hess [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 10:31 AM Subject: Re: SQL query I need to choose a group of records from a table based in the fact that a datetime field is not null .

Re: Accessing one external table

-- from: Mario Martinez R. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Wed, 24 Apr 2002 12:26:41 -0500 (CDT) How could I access inside one stored procedure written in transac-SQL one table holded in another SQL server??. Thanks in advance friends regards Mario Structure

RE: Macromedia XML feed contest

Hi all: Could someone tell me the procedure to subscribe somebody else in this list?? regards Mario _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

subscription

Hi all: Could someone tell me the procedure to subscribe somebody else in this list?? regards Mario _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

Accessing one external table

How could I access inside one stored procedure written in transac-SQL one table holded in another SQL server??. Thanks in advance friends regards Mario Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

Re: cfmailer decides not to work.

cfmailparam file= #FILE.ServerDirectory#\#file.serverFile# regards Mario --- Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED] escribió: Error Diagnostic Information no EXTENDEDINFO Diagnostics=Unable to write mail message to disk. An unexpected error occurred while attempting to save the

Test

I think I have problem .Please anybody sent me an email back to see If I can make post. Thanks Mario be 1:1? Jim - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 11:24 AM Subject: Can I do this with CF

Test

I think I have problem .Please anybody sent me an email back to see If I can make post. Thanks Mario be 1:1? Jim - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 11:24 AM Subject: Can I do this with CF

Re: RecordCount=0

Thanks Tony and the other that tried to help me out.. Down here is the code that is working ,The only thing I did was to change the order of operation in the cursors I'm using.I wonder why this is the solution??. Besides although I 'm getting the data I need at the end the stored

RecordCount is 0 en Stored Procedure

Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND

RecordNum =0

Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

RecordNum =0

Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

RecordNum =0

Is that down here correct?? I'm trying to detect is this query does not retrieve any row. It does not work for me. Ideas?? Thanks friends Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0

Help

I tried that and it does not work either. I think that the cause must be another thing. I'm posting the SP code down here to see if you can help me. I'm stumped with this. The problem seems being that the second cursor for some reason is not working. The parts commented were already tested

writing code dinamically

Hi friends: Down there is the code that is eating my brain. If I take out the piece: script function changeImages(){for (var i=0; ichangeImages.arguments.length; i+=2){document[changeImages.arguments[i]].src = changeImages.arguments[i+1];}}/script It goes better. The inclusion of anything

Re: Custom Tag

Until I know You can write anu CF code in a custom tag. You can reference the parameters as #Attributes.parametername# where parameter name is what you choosed. You can reference the output parameter as #Attributes.Result# if I don't remenber bad. But basically CF is great. Mario --- phumes1

Re: Custom Tag

Until I know You can write anu CF code in a custom tag. You can reference the parameters as #Attributes.parametername# where parameter name is what you choosed. You can reference the output parameter as #Attributes.Result# if I don't remenber bad. But basically CF is great. --- phumes1

Re: Custom Tag

I would pass a list as a parameter and make the whole stuff inside the custom tag code Mario --- Justin Scott [EMAIL PROTECTED] escribió: I have a custom tag that I want to add some CFIF statements but I'm not sure if this can be done. Has anyone had experience doing this before? I'm

null DateTime value

Hi All How can I write a null DateTime value in coldfusion?? regards Mario _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

Re: null DateTime value

Thanks Dave. I did that before. but when I pass an empty string to sql server to update a DateTime cell , what I see in the table is this wierd date: 1/1/1900 Any ideas?? Thank for replying Mario --- Dave Carabetta [EMAIL PROTECTED] escribió: - Original Message - From: Mario Martinez

Re: null DateTime value

Thank you Jim I gonna try this way. Thanks all regards Mario --- Jim McAtee [EMAIL PROTECTED] escribió: Use = NULL in your SQL statement. UPDATE thetable SET this = 'that', thedate = NULL WHERE something = #somethingelse# Jim - Original Message - From: Mario

Hopefully only a sintaxis problem.

Hi All: My problem probably is silly but is a pain in a knee for me. I have a cvs file from I need to pull some data in a QUERY. My cvs file have some name fields that end in the caracter ?.CF report me an error when I try to pull one this field in my query. Down here and example and what I see

Re: Hopefully only a sintaxis problem.

Hi All: My problem probably is silly but is a pain in a knee for me. I have a cvs file from I need to pull some data in a QUERY. My cvs file have some name fields that end in the caracter ?.CF report me an error when I try to pull one this field in my query. Down here and example and what I see

RE: Help! How can I extract a form from a webpage?

Ernie : After CFHTPP the page content is gonna be in #cfhttp.filecontent# as an string. After that you only have to use regular expresion and some string functions like REFind to get the data you want. hint:You can see html code of the page you want to retrieve in advance in your browser. I hope

Coldfusion function

Hi All: I'm coming today with perhaps a silly question. I have a complete template and I want to reuse its functionality . My question is : Is there anyway to create functions in coldfusion?? If so , which is the best option?? My function would only takes two parameters. Thanks in advance

RE: Coldfusion function

: Coldfusion function UDF's my friend. Of course you must have CF5. Check out cflib.org for some good examples of user defined functions. Kevin -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:19 PM To: CF-Talk Subject

RE: Coldfusion function

-Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 3:51 PM To: CF-Talk Subject: RE: Coldfusion function I got CF4.5 so , I think I can not use UDF's . An include file allow me to pass parameters??. Creating a custom tag could

RE: CFHTP Problem

--- Dave Watts [EMAIL PROTECTED] escribió: This is the problem that's eating my brain now. I need to access to a asp file that send me back a cvs file as attachment. I can not see how to get the cvs file. Down there is the piece of cf code and continuesly what I see in the client

ODBC and cvs files

Hi friends: I'm trying to make a query from a csv file (test1.csv). The way I thought was to make an ODBC entry for text files . In the ODBC entry I only can specify the directory not the file name. So I guessed I had to include that in the final query. There is something I'm missing . I will

Re: ODBC and cvs files

--- Marlon Moyer [EMAIL PROTECTED] escribió: Just a stab in the dark, but did you make sure test1.cvs is not marked read only in the file system? Marlon - Original Message - From: Mario Martinez R. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, April 09, 2002 12

RE: ODBC and cvs files

#,#attributes.something3#' CFFILE ACTION=Append FILE=#RostersFile# OUTPUT=#toutput# ADDNEWLINE=Yes The user then clicks the form button and it appears HIH David -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:49 PM To: CF

RE: CFHTP Problem

I solved the problem saving the file ,using an ODBC Text driver and setting the file as a datasource. Everything is working right now. But still remains my doubt on why I could not get the query directly from the CFHTTP. Thanks a lot Dave for your concern and help. You are great!! regards Mario

Administration problem

Hi All: Please check the site underneath http://skillport.nywired.org/test/cfusionss/end/index.cfm?userID=1552 coldfusion server is pushing up a line :*** in each template I request. Does anyone has had this problem before???. I have reviewed the settings in the administration page

Re: CFFTP Problem

1_Is that a valid file name??? CFSET remotefile1 = foo.mdb 2_Is that TRANSFERMODE=AUTO or TRANSFERMODE=AUTODETECT ?? I'm posting the completely help from Coldfusion studio down here to see if it can help.See and compare againsts the tested samples. Regards Mario. CFFTP CFFTP allows users to

RE: Administration problem

: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:03 AM To: CF-Talk Subject: Administration problem Hi All: Please check the site underneath http://skillport.nywired.org/test/cfusionss/end/index.cfm?userID=1552 coldfusion server is pushing up a line

CFHTP Problem

Hi friends: This is the problem that's eating my brain now. I need to access to a asp file that send me back a cvs file as attachment. I can not see how to get the cvs file. Down there is the piece of cf code and continuesly what I see in the client side. Any ideas??? Thanks Mario cfhttp

RE: Creating Virtual Directories using CF

what is a virtual application ??? Thanks --- Dave Watts [EMAIL PROTECTED] escribió: Has anyone ever tried to connect to IIS using CFObject in order to create a low-pooled virtual directory? When you mention low-pooled, that implies that you're really creating a virtual application

RE: SQL null field

Great!!!. I used IsNumeric(fieldname) but I seem this solution is more generic. Thanks people cheers Mariop --- Dave Watts [EMAIL PROTECTED] escribió: How to detect a null SQL field in colldfusion??? Thanks in advance. cfif len(trim(fieldname)) gt 0 the filed is not null

RE: SQL problem - HELP?

Try changing the protocol used in the server and in the ODBC entry or review the TCP/IP settings. I think the last is the best regards Mario --- [EMAIL PROTECTED] escribió: my advice. whenever you have SQL server errors that are really weird, go to http://groups.google.com and do a search in

RE: CFCONTENT - donwloads only a .cfm file?

Is there any way to know the header my browser is pushing out when requesting an specific page?? regards Mario 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:

header question

Is there any way to know the header my browser is pushing out when requesting an specific page?? regards Mario 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:

Re: header question

GetHttpRequestData() is a struct containing the header info sent by the browser to server. °¿° ~ Don Vawter - Original Message - From: Mario Martinez R. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 05, 2002 7:15 AM Subject: header question

SQL null field

How to detect a null SQL field in colldfusion??? Thanks in advance. Mario __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ:

Location trouble

Hi friends: I'm trying to log into a site remotely using CFHTTP. The login.asp redirect me to the home page if everything is OK. The problem is that the internal URL in the asp code seems to be relative. and I'm getting back a 302 code. Is there any parameter that I can pass in the CFHTTP to

Re: compilation error from POST????

try POST with capital letters. POST --- Jeff Fongemie [EMAIL PROTECTED] escribió: Hello everyone, For some reason, CF gives me an error with this line: FORM ACTION=https://myotjersite.cfm; METHOD=post I'm I missing something all of a sudden?? I've got a closing form tag

Re: CFTREE no longer delivering form node values?

where is the code?? regards Mario --- Ian Lurie [EMAIL PROTECTED] escribió: Hi all, I've got a CFTREE that I've been using, literally, for 3 years without a hitch. Suddenly today, we started getting CF errors indicating that the form.cats.node value is no longer being passed. I've

Test

Does anybody is receiving this email?? please send me back a reply. I can't see any post I do but I can see others. thanks Mario JT -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 12:22 PM To: CF-Talk Subject: Re: detecting an

Test2

Ok the first Test worked!!.I'm happy. This is the last test!!. Does anybody is receving this question I 'm writing down here. regards Mario Hi friends: I'm trying to log into a site remotely using CFHTTP. The login.asp redirect me to the home page if everything is OK. The problem is that the