It is the same connection.
I am merely making a copy of a working ASP directory and renaming it.
The global.asa file is the same as are all the other files.
I have a working asp directory on my web server.
I simply do a copy of that directory and renaming it.
When I pull it up in my browser, asp pages require a database connection will error with the below.
I don't understand why merely copying the directory is a disruption...
I have 2 tables
table1 fields
--------------
quote
status
I want to set up a table
table2 fields
---------------
quote
status
date
In the event that table1.status changes, I want a transaction log in table2. Any suggestions to point to the right direction?
I went ahead and ran the following
select wavr01
from proddta.F4801
where
WASRST = '60'
and WADCTO = 'TF'
and WAMMCU = lpad('101',12,' ')
and wavr01 <> lpad(' ',25,' ')
**********************
Only 40 records popped up and saw 2 records that were foul.
I corrected the bad data since it has to be...
select to_number(wavr01) Parent, wadoco child, 'C' Type
from proddta.F4801
where
WASRST = '60'
and WADCTO = 'TF'
and WAMMCU = lpad('101',12,' ')
and wavr01 <> lpad(' ',25,' ')
I get the error.
I'm getting the
ERROR:
ORA-01722: invalid number
How do I find the record in my view that causing the error?
Obviously there has to be some alpha letters somewhere.
I want to go about 5 years back.
Purpose is to feed a drop down list box on a web page.
I'll be Frontpage tool to connect to the Oracle DB Table or View.
I want a table with one field.
I want values to be the current year, the year before, and the year before that...etc....
I want this table to be updated on the fly.
I have the following, but these are in separate fields which I don't want happen.
select to_char(sysdate, 'YYYY')...
I am administrator on when logging onto the "Crystal Management Console".
For some reason I am locked out. It says
"All system 0's concurrent licenses are in use at this time or your system's license key has expired"
I am suppose to consult the system administrator. The problem is I am the...
I want my java application to display a FORM
where a user can paste from an excel sheet 2 columns onto a pane on the java application form. After pasting 2 columns of as few as one row to as many as a hundred rows, user will hit the submit button. This will ultimately update a table in oracle...
When I use length, it gives me the capacity of the BlockList. Is there any way to check if an array contains values that are not equal to "nothing".
Dim BlockList as String
reDim BlockList(50)
if BlockList.length > 0 then
end if
When I use length, it gives me the capacity of the BlockList. Is there any way to check if an array contains values that are not equal to "nothing".
Dim BlockList() as String
if BlockList.length > 0 then
end if
How do I exit 2 loops?
I want to be able to exit the Do loop and the outer For loop. Is that possible? How do I do that?
For i = i To UBound(tContents)
s = Trim(tContents(i))
'Check for end of file
If Mid(s, 1, 5) = "*SPC*" Then
ReDim...
I generated a ~.qry file that taps into a database.
I have a report based off of that ~.qry file.
I've been scheduling the report every morning.
First, I open the ~.qry file with SQL designer and then press the refresh button followed by the save button.
I then open my report file and press the...
What do I have to do here to make it both IE and Netscape compatible?
function Blank_TextField_Validator()
{
// Check the value of the element named EMPNUM
// from the form named Main
if (Main.EMPNUM.value == "")
{
// If null display...
I have a drop down list box name ListBoxURL in my JSP.
The variable Choice is read into my javascript correctly only if it is one word. If the user makes a selection choice that has 2 words like
"James No", only James will be read in as the Choice. How can I fix this problem?
var...
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.