Recent content by pitz77

TO_DATE('2004-10-25 10:36:22.0', 'mm/dd/rrrr'), Here's the error: ORA-01843: not a valid month How the heck do I convert that datetime into mm/dd/rrrr?

YAY!! Thanks Sem. Now that I know how packages can be so useful, my world as just gotten so much easier! Thanks for your help. If you have any really good online resources for Oracle/plsql, can you send them along to me? Thanks again!!!

Sem - your idea of creating a package variable sounds good. I've only been using Oracle for a few weeks. So, one question: how do I create a package variable for a select count(*) statement? Thanks Lisa

the check itself is: SELECT COUNT(*) FROM TableX WHERE... The problem: The AFTER INSERT trigger is on TableX. You can't select anything from TableX within the AFTER INSERT trigger on TableX, because it causes a MUTATION ERROR!!

Well, i checked around and a BEFORE INSERT trigger will not cause a mutating error - and it doesn't, i've tested it. "duplicate" row is something that will occur on the table and needs to occur on the table. "duplicate" to me, means that the CLIN_NUM is duplicated. If it is duplicated, i do...

OK, here's what I'm doing: I want to disable my AFTER INSERT trigger by checking if the new row is a duplicate or is new (based on the criteria in the stored procedure). The BEFORE INSERT trigger calls a stored procedure which will enable or disable the AFTER INSERT trigger. The problem: I...

Um, ok. <cfabort> will actually abort processing any further code. That's not what I want it to do. As for the function... <cffunction name="foo"> <return = "foofoo"> <cfif A=B> <cfreturn return> break here and do not process any further code in THIS function. Continue...

will <cfbreak> work when I want to do the equivalent of ASP's "Exit Function"?

Do you have any idea where "anyvalue" is coming from? it's not in your code. If you turn on debugging, it may show you what query was run so that you can trouble shoot what's coming out of the first query. i.e., ident_type_id may not always be a number? Check the datatype of that field and...

For the first query, since you are not doing ANYTHING with the rows that return NULL for ident_value, you can filter the first query but putting in "WHERE ident_value IS NOT NULL". This way, all ranges will have an ident_value. Here's what the query would look like: <cfquery name="form_info"...

wemigit Thanks, but neither of those will work for me. The first and second both set numerics to empty strings, which will certainly fail. I still have yet to come up with a solution. Any ideas are still welcome...

Nope. I did that and I get this error because I use "fooPostBackVar" to define "fooLocalVar". The required parameter fooPostBackVar was not provided. This page uses the CFPARAM tag to declare the parameter mon_CLINqty as required for this template. The parameter is not available.Please...

Hi, I would like to default a numeric variable to empty. The situation is that I've got a page that takes FORM/URL scope variables from the previous page and from a post back of itself. Here's some code: <cfparam name="fooPostBackVar" type="numeric" default=??> <cfparam name="fooLocalVar"...

<cfparam name="foo" type=? default=""> <cfsavecontent variable="foo"> stuff </cfsavecontent> I would like to set the datatype for "foo", but "string" doesn't work. Any idea what the datatype is for a cfsavecontent variable?