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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
JSTL NULL DATE
I tried to update a record which has a date field. Following code works fine when it has a date value. However, it is not working when that field is null. <fmt:parseDate var="ADOB" value="${param.DOB}" dateStyle='short' /> <sql:transaction> <sql:update var='updateDemo'> UPDATE T_PATIENT_DEMO...- leekikwan
- Thread
- Replies: 0
- Forum: General e-Business discussion
-
JSTL null date
I tried to update a record which has a date field. Following code works fine when it has a date value. However, it is not working when that field is null. <fmt:parseDate var="ADOB" value="${param.DOB}" dateStyle='short' /> <sql:transaction> <sql:update var='updateDemo'> UPDATE T_PATIENT_DEMO...- leekikwan
- Thread
- Replies: 1
- Forum: Sun: Servlets and JavaServer Pages (JSP)
-
Can I run SQL query typed in TextArea in ColdFusion forms?
What I want to do is that when user type in the sql query in textarea box, it is excuted in the next page. I have tried as follows. It is working when I run select SQL statement. However, when I run update or insert SQL statement, I get "The page cannot be displayed. HTTP 500 - Internal... -
ORA-00911: invalid character error
I have found out the solution. The problem was NEXTDT variable. It create a ODBC timestamp date string and ColdFusion 4.5 does not handle it very well. (It works Verision 5.0 and after). I have corrected it as follows. <cfset NEXTDT=DateFormat(NEXTDT,"mm/dd/yyyy")> <cfquery NAME = "AddRecord"... -
How can I display their user name on every page until they log off?
I have created a log in feature as follows. I now want to display username on top corner of every page they visit. Will you tell me how I do that? Application.cfm <!--- Create the application ---> <cfapplication name="MyApp" clientmanagement="Yes" sessionmanagement="Yes"... -
ORA-00911: invalid character error
When I run following cfml file in CF V4.5, I get ORA-00911: invalid character error. <cflock name="InsertNewRecord" type = "EXCLUSIVE" timeout="60"> <cftransaction> <CFIF #FORM.MELD# LE 10> <CFSET NEXTDT = DateAdd("d", 365, "#FORM.MDATE#")> <CFELSEIF #FORM.MELD# GE 11 and #FORM.MELD# LT 19>... -
clob field in CF 4.5
Following field's datatype is clob in Oracle. ColdFusion 4.5 does not display the information in that field. How can I fix this? <td><textarea name="PNOTE" cols="90" rows="4">#PNOTE#</textarea></td> -
Display the sum of queried results.
I want to calculate the sum of the 2 queries' outcome. For example, I would like display the sum of ANCAL and BSCAL. <cfquery name="NCBMTCOUNT" datasource="abc"> SELECT COUNT(*) ANCAL FROM NTN.DEMO D, NTN.XPT1 T WHERE (D.MRN=T.MRN) AND T.XTYPE LIKE 'HT' AND D.HUB = 'NCAL' </cfquery>... -
Got error when updating record with blank date
Thanks thousands. It works. -
Got error when updating record with blank date
I am having a error message when I update the record with blank date field which is formatted as follows. <cfquery NAME = "EditRecord" datasource="xplant"> UPDATE T_TRANSPLANT SET RDR='#FORM.RDR#', REFDATE=TO_DATE('#FORM.REFDATE#', 'MM/DD/YYYY')...
