I have inherited a database application. The app has 70 procedures, which run quarterly. The client would like the 4 quarters run so that the output is sent to a separate database for each quarter. The procs are updated every quarter with client requests.
Currenlty I have 4 databases where...
I am trying to open a new window without the toolbar and put the focus on field1. I would like to close the old window as well. What is currently happening is the new window is opening and I guess the onload event keeps oepening new widnows...etc. How do I stop multiple onloads ?
abc.asp...
What is exactly the difference in use ?
I know err.number needs the On Error Resume Next statement at the top of the ASP page but does objConn.error also need this as well ?
I have code like this that checks for database errors:
IF objConn.Errors.count > 0 THEN
For Each...
I am comparing session variables to null. I am getting different results dependending on how I code the if statement below :
<%....
if isempty(session("x")) then ... ;this seems to work INcorrectly if x is null
if isempty(response.write(session("x"))) then ... ;this works...
I am checking if a number exists in the database on the server side using ASP. If that number is not found I would like to send a messge to the screen via an alert (or document.write). then I would like the original screen back with the invalid field highlighted..I tried this but when the alert...
How can I put a table next to another table when the table on the left is fixed at 1 column by 9 rows and the table on the right is 4 columns by n rows ?
thanks
hanton
I have a form with 96 fields. I need to find a way to create an SQL Update statement for all these fields without explicitly specify each field in my asp file.
Can this be done from the form collection ?
I know you can get the form element values like this :
For Each MyItem in Request.Form...
I have a main.asp driver program that checks what the NextAction is and based on this 'value' will call another program.
There are 4 pages each of which has a submit button with value='submit' (this is what the users want). So, I have 4 submit buttons and each has a value=submit. In the driver...
I would like to create a cross reference table with 3 columns :
key field, english_translation, french_translation
How do I create this table so that the french_translation column is defined as French chars ?
thanks
hanton
Interdev 6
I have created web sites using ASP and coding the programs manually. Ithough I would give this tool a try because I can create a formatted page in minutes. However, It is a struggle. I am able to format my pages but am struggling with how do the responses. Have decided to manually...
I would like to apply styles to the entire web site; using external stylesheet. But I am having problems defining the sytle for form submit buttons. I don't want to use classes (
<style type="text/css">
.button {
background-color: maroon; color=white; width:150px; }
</style>
...
Can anybody help me speed up this query ? I have an index on
p.pptyno and pn.pptyno. Is there anyway of recoding the date logic in the where clause ?
select
count(*)
from
pn,
p
where p.pptyno=pn.pptyno and
pn.filedate>=decode(p.saledate,0,p.adjdate,p.saledate)
thanks
My web site pulls up a cr7 report on NT using IIS. I can bring up my site but when I click on the crystal report link on a client machine I get the 'open file with screen'.
It seems that the browser is not getting to the Crystal web server. I have set-up a virtual directory to point to the...
My web site pulls up a cr7 report on NT using IIS. I can bring up my site but when I click on the crystal report link on a client machine I get the 'open file with screen'.
It seems that the browser is not getting to the Crystal web server. I have set-up a virtual directory to point to the...
NT 4.0 (SP6)
I download the option pack from ms and when I installed the NTOptionPack I get an error message that says
"this has not been tested with service pack 4.." I selected NO and continued withthe install. After the install compledted I tried to start PWS and could not. I click...
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.