The z index does not work. This only happens with a select box. No other input item such as textbox, etc. They always appear behind the menu. Only the select box appears over top of it.
When I click on my menu bar and it drops down the list if a select box is on the screen near it the menu list falls behind the select box. Is there any way to make it so the menu will go over the select box so that I can see all the menu items
I am trying to run a page where i make a large update to an sql server database. If I run the update but only update a few records aprox 15 or so it will let me update. However if i try to update a large amount of records 20 or more it
gives me this error
Microsoft OLE DB Provider for ODBC...
I am trying to run a page where i make a large update to an sql server database. If I run the update but only update a few records aprox 15 or so it will let me update. However if i try to update a large amount of records 20 or more it
gives me this error
Microsoft OLE DB Provider for ODBC...
Here is the update code:
con.execute("Update DaysTaughtAndClaimed set recdate='"&request("recdate"&getrec("id"))&"',Reason='"&Replace(NewReason("Description"),"'","''")&"'...
Also on the page I retrieve names out of a multiple select box and run a report on them. if I select one or two it works but if i select a large amount I get the timeout error.
I can run this page and it works when I connect to an acess database, with the same code(of course the small changes like the connection string etc.) but it wont run when I connect to sql server.
database is on same machine,
I am not using DSN
here is my connection string
Con.ConnectionString = "Driver={SQL Server}; SERVER=test1;UID=; PWD=; DATABASE=test"
I am connecting to a sql database and when I run a page I get this error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver]Timeout expired
How can I change the length of the timeout.
I am trying to pass the variable from a multiple select box to a print page. However I am not getting all of the variable because it is getting cut off. How can i pass avariable through the url that is large.
I was wondering if there is a way to set the field I am using as my primary key with the identity seed back to 1. I put in 10 records as a test and then deleted them. Now when I put in a new record it starts at 11. is there any way to reset this back to 1.
I am trying to create a report for work attendence but i want to converger consecutive records.
Instead of this
From To #ofDays
01/01/03 01/01/03 1
01/02/03 01/02/03 1
I want this
From To #ofDays
01/01/03 01/02/03 2
Is...
I response.write it and get value of nothing for request("theDate").
I could put the two sql statements one under the other. The first brings me a request("theDate") as a date
and the second brings me nothing. Does the first one erase the variable of any value.
I have two record sets with almost identicle syntax one works and one doesn't.
I have this first
set getPercentage=con.execute("select * from Global where recDate="&request("theDATE")&"and school='"&session("account") &"' and...
In SQL Server how do you sort records. If I click on my id field and highlight the whole field how do I sort it either descending or ascending. The button to do this is always greyed out like it is unactive.
I am creating the table by just importing existing tables fromm Access. Because I did not create the table only import it in can I change a field to set an Identity in design view or can this only be done by creating your own table.
I am creating database in SQL Server by importing an existing database from Access. I want to be able to still have ID as an autonumber. Is this possible?
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.