I have a database which stores information,I have a page which has links to each of the rows in the database and to search by each row it has its own unique ID. The problem I am having is only one row keeps getting returned from the database.I have an access database and using ASP. I think the problem could be with the SQL statement.
SQL = "Select * FROM monitoring where monitoringID = & request('ID') &"
im trying to display a name from a table, by matching up where an assigned_to id = emp_id in another table. Code:
View Replies View RelatedI have a table that has ticket number displays as a link.When I click on a ticket number it displays no data was return. (" it's not reading the ticket number I choose")Can someone look over my codes and tell me what should be doing! I am a the final part and I lost.
View Replies View RelatedI have written some ASP code that selects some records from a SQL database according to a criteria, if no information is found in the database then it sees there is an End Of File in the object record set and prints the line below:
<%if objRecordset.EOF then Response.Write("No information was found for the record you have entered") %>
My problem is that if no records are found it still tries to print the information that it is looking for and cannot find and thus throws an exception. The code for that is below:
<Table Border="1" BGCOLOR="white">
<% Response.Write "<TR><TD>The date for that record is " & objRecordset("DateTime") & "<br></TD></TR>" %>
I have some asp that should be inserting a shopper into my SQL Server DB. Code:
View Replies View RelatedI have an employee phone book application that is 5 years old. Written in asp with vb script calling sp's. when someone queries the all employee page they get all employees. When they then query employees by location it will again return the all employees data.
I changed the RS names in the all employee page in hopes that would fix it. I added the no cache code on all my pages and this hasn't helped. This app is 5 years old and hasn't changed at all but this just started happening within the past 6 months. When the user clears all cache and tries again it will work. How do I fix this?
What is a faster/better coding practice?
Method 1:
Code:
Sub myFunction(byRef x)
x = x + 1 ' do something with x
End Sub
x = 7
myFunction(x)
response.write x ' shows 8
Method 2:
Code:
Function myFunction(x)
myFunction = x + 1 ' do something with x
End Function
x = 7
response.write myFunction(x) ' shows 8
Also discuss considerations when there are more than one variables that need to be changed.
I've always been looking for the best way to get an accurate percentage
statistics.
For example, in a election scenario:
Person A gets 33 votes
Person B gets 33 votes
Person C gets 34 votes
Person D gets 35 votes
Total votes = 33 + 33 + 34 + 35 = 135
Percent for A = 0.244.... = 0.24 = 24%
Percent for B = 0.244... = 0.24 = 24%
Percent for C = 0.251... = 0.25 = 25%
Percent for D = 0.259... = 0.26 = 26%
Then add up the percentage values: 24 + 24 + 25 + 26 = 99
(where it should be 100)
So, does anybody have a way to get around this problem? How should I
calculate the percentage for each person so that the percentage will add up
to 100 in the end?
I am trying to parse this response.write string but its coming up with a formatting error - can someone please tell me where I'm going wrong?Code:
Response.write ("<input name=""URL"" type=""text"" value=""http://www.evolvewebsitedesign.com/news-indiv.asp?news=" & rssite("News") & ""/>")
I am needing to response.write a variable within a snippet of Javascript.
My Javascript code that I need to response.write with the variable is below:-Code:
response.write ("imageArray[ImageNum++] = new imageItem(image_dir + ""variable here"");")
I can response.write the static Javascript string fine. The problem arises when I try and state a variable into where it says, 'variable here'
The variable I need to include is
Code:
rs.Fields("ImgURL")
Would someone please be able to show me the correct formatting for this Javascript string which includes the variable.
My asp syntax is very lacking, it seems the double quotes that have been
done by me are not what asp is looking for. Anyone that could correct my
faulty thinking would be thanked.
how to display correct time according to user timezone
i want to do an online meeting let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time
I have a form where users can enter search criteria for various products.
now, if this form has 2 fields, colour and size (it wil have more but I'm
assuming the the principle for two fields will be the same for ten fields)
what would be the correct syntax for performing a query where the user
didn't enter a criteria for both fields?
the search string would be
strSQL = "SELECT * FROM products where colour = " & "'" &
request.form("searchstrcolour") & "'" & "AND size =" & "'"
request.form("searchstrsize") & "'" & " ORDER by price"
so if the user selects blue and large, thats fine
but what if the user only selected say blue and didn't bother with the size?
is there a wild card that I could use?
can someone explain to me the diffrence between the 2 below and why one works and the other one doesnt.could you also explain what each part of the correct version is doing because i dont really no.
INCORRECT
sql = "SELECT * FROM userlogon WHERE (username)=' "& (username) & "' AND (password)=' " & (password) & " ' "
CORRECT
sql = "SELECT * FROM [userlogon] WHERE [username]=' "& username & "' AND [password]=' " & password & " ' "
is it active server pages or application service provider .which is correct
View Replies View Relatedchk whether the code is correct? For the update date
SQL_query1 = "update Activity_Status set TotalTime = '" & Request.Form("time") & "', Score = '" & Request.Form("QuizScore") & "', Activity_Name = '" & Request.Form("QuizType") & "',ActivityDate = '" & "#" & Date() & "#" & "' where UserID ='" & Request.Form("username") & "' and Activity_Name='" & Request.Form("QuizType") & "'"
i need to delete some values which have dates that are less than today's from a table. The date is in another table so i joined the two tables together and gave a clause
I did this:Code:
DELETE *
FROM RMASerial, Sold
WHERE RMASerial.SoldID=Sold.SoldID
And Sold.Warranty_date<Date();
But that doesnt seem to be working.
I have a few pages that require login to access. Assuming a user clicks a
link containing a variable trying to access a password protected page. That
user is redirected to the login page. After login, he's brought to a "logged
in" page. How do I retain the original link he clicked and instead of
redirecting to a logged in page, he's redirected to the page he originally
requested?
Im trying to make a client area on my website and an not sure on how to go about editing clients details.When the client logs in they are brought to a menu where they can update there record. How can i get the appropriate record from the database so they can update there details?
View Replies View RelatedOn asp.net, How can we programmatically verify whether the UserName and Password is Correct? and when i close the application directly and open again, is still in lon in status.?
i have this function in asp that should return false when a match is not found, but it keeps returning "exception occured". How do i go about getting this thing to work properly.Code:
public function isValidUserName(byVal user_name)
dim sqlComm
sqlComm = "SELECT USERNAME FROM S_USER WHERE USERNAME = '" & user_name & "'"
set oRs = oConn.Execute(sqlComm)
' if a match is found then return true
if oRs("username") = user_name then
isValidUserName = true
else
isValidUserName = false
end if
end function
how to display correct time according to user timezone. i want to do an online meeting
example: let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time are there any tutorials to do this.
I have set with lcid value. but i am not able to overcome my nt server regional setting. Actually i want a date in mm/dd/yyyy. But i get date as mm/dd/yy. How to ensure that i shall always get correct format irrespective of os or regional setting.
View Replies View RelatedI'm looking at another developers code and I'm now confused about the correct way to close a database connection and destroy the object. I would normally do it this way: Code:
View Replies View RelatedI'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code:
I'm getting an error on my ASP page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'StoreFileIntoField'
I assume - 99.5% - the error is generated because of worng value types,
I attemp to pass from my ASP/VBScript page to the VB/DLL function.
My relevant ASP/VBScript Code is:
I want to insert a value into the database.The values are obtained from textboxes.When i try to insert i am ending up with the error:
No value given for one or more required parameters
The part of the code is:
new1 = Request.Form("new")
tab = request.form("stcode")
<%sql="INSERT INTO movable1 (" & TAB & ") VALUES(" & new1 & ")"
conn.execute(sql)
if err<>0 then
response.write("Error")
else
response.write("The " & new1 & " was added under " & tab & ".")
end if
%>
the field is a numeric field.Could anyone figure out what is the fault?
I am having much difficulty having a form write to a DB... I am an ASP newbie and am noticing the errors are pointing to this script... currently this script is producing no error messages but when a user selects one of the chk options in the "Nominator code" section of my code, it won't write to tblNomCommVotes. Code:
View Replies View RelatedI am trying to run one of my first ever asp scripts. It is a form I copied from the
w3schools website along with its ASp script, demo_add.asp, both which i have
modified very slightly(variable names for my own database etc).
However, "No update permissions" appears in my browser when i run the script -
this means that there is an error. The problem is i dont what the error is!
The only thing I can think of at the moment is maybe my database location. I
am using IIS are all my files are mapped to a virtual directory within IIS. Should
the path in my HTML file below be to the harddrive location or its location within
the virtual directory? Im assuming it is the hard drive location. Code:
FORECAST
Month 1 :
Month 2 :
Month 3 :
Month 4 :
Month 5 :
Month 6 :
Thereafter :
[IMG]forecast.jpg[/IMG]
There is a forecast table which needs to be filled in for each client as shown above, all the info is then saved in the DB and from this data I will need to generate a FORECAST REPORT (shown below). It forecasts the prospective amount of records we will receive for processing.
[IMG]forescast1.jpg[/IMG]
The columns are shown below… june, july, august, September, October, November are dynamically generated on form load, using the current month and working 6 months ahead. Thereafter represents any month after November (6 months from june).
I am having huge issues populating the correct columns shown below with the correct values from the db, so if the forecast for july is 1000, how will I display it in the 6th column in my report? Code:
how to correct the database insert issue with characters like ' and ,
I remember a while back I used a function to replace this, and that fixed the problem, but it was so long ago I have misplaced it and forgotton.
I am doing ASP.Net and I really need the code for this...
somebody here could share the hard code if how can I check if the username and password are correct? just an example of piece of code or a hint only....
My Website is already in use and active . I have a problem with the date format . when I retrive a date from my database it is in the following format mm/dd/yyyy and I want it to be in this format: dd/mm/yyyy .
I asked for support from my hosting company . they said you can do that by manipulting through scripts . the date settings in my database is in the following format: dd/mm/yyyy .