>ALTER TABLE whatsnew ADD (image varchar2(100));
>I also tried:
>ALTER TABLE whatsnew ADD column image varchar2(100);
>
>but I get the error about line 4 of the cfm. This is a reference to
>the text field from the form that contains the above line (alter
>table...):
>The error occurred in
>hhp/htdocs/HHPv1/WNFunctions/DatabaseFunctions/addsql.cfm: line 4
>
>2 : <BODY>
>3 : <CFQUERY NAME="SQLEXE" DATASOURCE="dpch">
>4 : #sql_statement#
>5 : </CFQUERY>
>6 : <B>SQL Statement Executed</B
1) Make sure the "dpch" datasource has ALTER permissions in the MX
Administrator (which it does by default, but it may have been changed).
2) Remove the semi-colon after the statment. MX (and I'm assuming JDBC)
doesn't like semi-colons in SQL statements in MX.
>Also, can anyone tell me how to query for just 3 records in Oracle?
>I know how to do it in mySQL, but...
>
SELECT myColumn
FROM (
SELECT myColumn
FROM myTable
WHERE myCondition = 'foo'
ORDER BY myColumn
)
WHERE rownum <= 3
Regards,
Dave.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]