I have my webserver and a database. Things started to slowdown a ton with
access, permissions denied (it is on a Windows XP machine, 10 session limit,
etc).
I moved my database off the webserver to a faster and more secure location.
I can't access the database through the webserver anymore.
I am using Windows Authentication. I understand that the webserver will be
using the IUSR_xxxx account to access the database. I am at a loss on how
to access the database.
I am starting to create a seach page that will seach a database based on values entered by the user. I have the actual seach working but now am working on the user interface.
What I would like is to have a screen with 2 rows of text boxes(search parameters) where the user could enter a name or location to search on the database with. AFter data has been entered and the user clicks on the submit button I would like the results to be displayed on the bottom half of that same page with the original search parameters at the top of the page. I don't want to open a new page to display the results.
We have a couple of web applications where data is updated on a weekly
basis. The data entry is done in a vb access application which is kept
internal. The database is uploaded to the web which has a web interface for
clients to check their records. Thus dat a gets updated once a week.
In a new application, I would like to build a single web based application,
where the data entry is done from the same application and clients would look
up their records from the web. The clients should have only read access. In
other words, I would like to do the system real time. My question is whether
I would face any problem when somebody needs to edit a record while a client
wants to read record.
Can someone tell me where ive gone wrong here, this my first attempt at writing a dim myself...
Dim trades
trades="
if t_plaster,t_hs,t_plumb = Yes
Then
Response.Write ("<img src=""/images/yes.png""/>")
else
response.Write("<img src=""/images/no.png""/>")
end if
"
I am authoring a dynamic web-based project managment system, and I was wondering if anybody could help me with this situation. As of right now the database connection strings are located in each and every page.
I was pondering if there was a way to make a configuration file (similar to phpBB2 setup pages) where all of the data such as: database strings, settings, and variables are stored.
i have an SQL field search with start and end dates (first five lines code below) this works fine.
have added radio button "SignOff" so user can search fields where case has been signed off, not signed off or both (normal return). The sign off date (date_closed) is either a date or NULL, where radio button choice 'two' is NOT NULL ie there is a closed/sign off date, and 'three' is NULL.
as mentioned the first if statement works fine but when i introduce the SignOff statement below, the wheels fall off. I have forced through the SQL statements used and these seem to work so I am presuming my if statement format is faulty. oh, and if it hasnt come across already, I am a VBA/asp beginner. Code:
I am having a problem which thus far only seems to be fixed when I refresh the page. The basic process is as folllows:
1. Select details from the DB and display on screen.
2. Click a link 'Generate Docs'.
3. This then goes to a page which first selects from the DB using information passed through the URL from the above link to identify the correct records. We then create a PDF file based on the data from the DB and display the link to the newly created PDF. The problem, is that at step 3 the PDF does not get generated on the first pass, only if you click the refresh button on the browser.
I have checked all the obvious items, ensuring variables are assigned correctly and called correctly, I have tried implementing a number of 'must revalidate' style tags in both ASP and HTML, I have checked through all of the queries to ensure they are being processed and the data is returned on the first pass and they are and nothing thus far has worked.
I am having a problem getting some data fields to display in currency. Below is how I am getting the currency fields calculated - this works fine, no problems here, they do display. Code:
View Replies View Related