Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
TO_DATE() question...
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?- pitz77
- Thread
- Replies: 2
- Forum: Oracle: All versions
-
disable AFTER INSERT trigger from the BEFORE insert trigger
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...- pitz77
- Thread
- Replies: 9
- Forum: Oracle: All versions
-
<cfbreak> for a recursive function?
will <cfbreak> work when I want to do the equivalent of ASP's "Exit Function"? -
empty or null default value for a numeric variable
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"... -
datatype for cfsavecontent variable?
<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?
