Description:
Microsoft Internet Explorer newsgroup.
|
|
|
website asp db design
|
| |
I would like to use SQL server as my asp website database. I would like to know that is it a good idea to create 2 databases one for all the link and the other one fo real database for security reason. Since the dynamic website must let user login when user hit the home page to get url link information, it can avoid security issue if user... more »
|
|
|
Dup entries when creating a new DB entry (ASP Classic with an MDB file)
|
| |
Hi guys! (Hi Bob) Been a couple years since I've been here. I used to try to help people here with their questions (within my limitations). But now I am here with something I am stuck on myself. I am having problem with my ASP page creating a new database record *twice* when I submit the page. This creates a duplicate records (except for the... more »
|
|
|
IIS 6.0 and SQL Express 2005: Change Database (DEV -> PROD)
|
| |
Hi All, I was working on a DEV machine with Vista with IIS 7.0 and a local SQL Express 2005. Everything worked fine. I put the website on a memory stick, copied over to PROD, and now there are SQL connection errors. PROD has IIS 6.0 and a local SQL Express 2005. The message is below, but I'm not sure how to T/S because the server... more »
|
|
|
Parameterized query problem
|
| |
Hi all I'm trying to do a really simple query but passing perameters to it so liest say I have somethin like this Function ExecParameterisedQueryAndRetur nResultSet(sMainQueryString, sWhereClause, aParamName, aParamType, aParamDirection, aParamSize, aParamValue) Dim dbConn, SQLcmd Dim iNumElements, iLoop... more »
|
|
|
Wrong Database During Higher Web Server Load
|
| |
Hi all, Our issue is a little complex. Our system is an update from a legacy system that had our clients host their own databases and software. We are now completely ASP.net based, but have each of our clients data in their own SQL Server 2005 databases. Currently we have about 150 clients migrated and... more »
|
|
|
Cannot connect to MSSQL2005
|
| |
Hi I'm trying to connect a ASP Classic 3.0 script to a MSSQL2005 DB Here is the connection code <% Dim conSQL Set conSQL = Server.CreateObject("ADODB.Con nection") strConn = "Provider=SQLOLEDB; Data Source=(local); Initial Catalog=MyDatabase; Integrated Security=SSPI;" conSQL.Open strConn If conSQL.State = adStateOpen Then... more »
|
|
|
error '80020009'
|
| |
I have the following: sqlstr = "SELECT Budgets.Cilcode, Budgets.[Cost Centre], Sum([Day]/60.0/8.0) AS TSDays FROM (CIL.dbo.TIMEBIDTS INNER JOIN CIL.dbo.TIMEBIDUSERDEFTS ON CIL.dbo.TIMEBIDTS.taskID = CIL.dbo.TIMEBIDUSERDEFTS.TaskI D) INNER JOIN CIL.dbo.Budgets ON CIL.dbo.TIMEBIDUSERDEFTS.Budge tID = CIL.dbo.Budgets.ID... more »
|
|
|
form selection issue
|
| |
Rich wrote: ...<sigh> Bad design. Data should be stored in the rows of the table, not in the names of the tables. The "year" is data that should be stored in a column of a single "tags" table. ...Why wouldn't you simply put a simple textbox that defaults to the current year? Why are you thinking of creating all these buttons that... more »
|
|
|
screen scraping with a twist
|
| |
I've been looking around and can't find or figure out what i'm really going after. I'd like to be able to screen scrap the current web page that i'm on. This page would have some input type =text textboxes that the user can input data into.. say their name "John Smith". i want to be able to click a button... more »
|
|
|
|
