Just for info.
Some macromedia extentions are a nightmare. It has a habit of adding a the @ directive to the page. I have found this the case if when adding code from an extension if it is looking for an @ directive with a code page or vice verse then the duplicate @ is added either just below...
Hi Ken
The Job is scheduled vi DBA Jobs which was recently changed with in the last day or 2 to start slightly later.
However last night it failed and when I just went to run the proc the scheduler started at the same time!? which is slightly strange.....
It is just weird.
Glen
Conception...
Hi Guys
I recently updated the time of a scheduled job on our Oracle system. Now when the job runs or the procedure is run it starts the scheduled job at the same times then fails.
When the scheduled job is started manually it tries to run it 3-4 times resulting in failures.
Has anyone seen...
Hi Guys
This might not be the right place for this question, if it isnt let me know and i'll find the right forum.
I have a selection of links that when i roll over them they go an alternate color,this works but what i need is for the link to stay that color when clicked and revert back to the...
Hi
Sorry to revisit this.....what database are you using? If it is SQL server make your SQL in to a stored procedure and run it as an SQL job and schedule a time and day/days for it to run.....this way the database does all the work and you can set it to a time when load is at it's lowest.
You...
Hi there are a few good posts about this already on here.
The simplest way is to:
str = 'hello@youdomain.com&?'
str = Replace(str,"@")
str = Replace(str,"&")
str = Replace(str,"?")
Although you could place this logic in to a function or even use the regExp object etc..
Hope this helps...
hi
This is what I have to do the same.
<script language="vbscript" runat="server">
Sub Application_OnStart
' Set our user count to 0 when we start the server
Application("ActiveUsers") = 0
' Count Active Users
'-----------------------------------------------
Sub Session_OnStart...
Hi
Its your asp response.write or rs("whatever") thats causing the problem.
Post the rest of the code and i'll have a look.
Thanks
Glen
Conception | Execution
Hi
I would do this on the server like so...
<%
' See if the form is submitted
if request("search") OR request("update") <> "" then
' Get our fields
For ix = 1 to Request.Form.Count
fieldName = Request.Form.Key(ix)
fieldValue = Request.Form.Item(ix)
Session(fieldName) = fieldvalue...
Hi
Agree with the .net comments!!!
Right, to answer your question.....
<%
'ASP Code for handling DB etc
If Request.Form("field1")<>"" then
usp = CreateObject("ADODB.Command")
usp.ActiveConnection = "Driver={SQL Server};Server=SERVERName; Database=database;uid=userid;pwd=password"
Dim sql ...
Hi
If you are doing this in an intranet we use windows login name for our security.
If InStr(1, Request.ServerVariables("LOGON_USER"), "\") > 0 Then
LoginName = Mid(Request.ServerVariables("LOGON_USER"), InStr(1, Request.ServerVariables("LOGON_USER"), "\") + 1)
End If
Just a smalll...
Hi
The folder that has the database in it needs write permissions [on the IUSR_MachineName account] so that it can create the temporary lock files etc..
You may also want to apply this permission to the database but I would look at this and the potential impact before doing that.
Thanks...
Hi
I would be careful using the database column names for a couple of reasons....
Firstly as with good database design practice the column names may not be formatted/easily readable or describe the data accurately.
Secondly it is never really a good idea to let everybody see what columns you...
Hi
I would personally use a scheduled task and/or trigger in the database to do this.
then you can do automatic daily mails and 'on status' change database updates.
Just a thought.
Thanks
Glen
Conception | Execution
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.