Sheco and Turkbear,
Thank you for your responses. I was using a DSN, I switched the the DSN-less connection code above and receive a different error.
I'll keep working with it, thank you for getting me pointed in the right direction.
I have an asp script set to pull records from a database and display a table to the end user but I receive the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in OraHome92)...
When I try and run the query in SQL Plus I receive an error message "missing SELECT keyword" on the from statement. Do I have the table joins set up correctly for Oracle?
I'm fairly new to PL/SQL so I'm hoping some body would be willing to help me convert the following SQL into something the SQL*Plus will be happy with.
Thank you for any assistance you can offer.
SELECT MESSIAHDB_BIB_TEXT.TITLE_BRIEF,
MESSIAHDB_LOCATION.LOCATION_NAME || ' '...
I'm trying to add values from a form to an Oracle database. Here is my asp code.
<%
Dim Conn
set conn = server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Data Source=InternApp;User ID=Intern;Password=intern"
conn.open
set comm = server.CreateObject("ADODB.Command")
set...
I'm working with a web form and I've created a PL/SQL script stored at the database to add records. How do I call this from my ASP code?
How do I set up the connection to the database?
TIA
You are correct, I did miss one of the changes suggested by Holgram. After that corrected I still receive the following two errors:
1.) cannot resolve symbol
symbol : variable response
location: class ProcessForm
response.setContentType("text/html");
the ^ is under the r in response...
Now I receive four messages
1.) cannot reslove symbol
symbol : method getParameter (java.lang.String)
location: interface javax.servlet.http.HttpServletResponse
String name = request.getParameter("LNAME");
the ^ is under the . between request & getParameter
2.) cannot reslove symbol...
Here are the two error messages I'm receiving
ProcessForm.java:13: cannot resolve symbol
symbol : variable request
location: ProcessForm
String name = request.getParameter("LNAME");
the ^ is under the r in request.
Here is my code
//Import Servlet packages
import javax.servlet.*...
I've finally figured it out!!!! After recreating the report and began to reduce the height of some of sections to reduce the number of pages, I reduced a group footer and scrolled through the report and noticed that again some of my totals stopped displaying on the later pages, when I undid the...
@percent is a numeric value such as 100 or 45 etc. It's the percent of their total salary that is paid out of that account number.
Perhaps, I just don't understand why it is displayed correctly for each group on page 1 - 39. I think this might actually be a bug in CR. I saw an article posted...
I've created a running total field summarizing Prem which is a formula field with the following calculation (If {Employee.b2_dpremiu}>{Employee.b2_epremiu}Then {Employee.b2_dpremiu}Else{Employee.b2_epremiu}) * {@Percent}. The type of summary is sum, it's evaluated on each field, and reset on...
Thank you for your response, however that didn't work. This is a fairly simple report that is just creating a running total on a salary field that is grouped by account number and all records for that account are visible in the detail line.
I have a summary field that is reset at the group level which prints correctly on page 1 - 40 page 40 - 53 it does not appear??? Does anyone have any ideas what is going on?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.