Digga,
I appreciate your effort.
Your suggestion will only give the session values of the user that browsed the site.
What I need are all the session values of all the users that are browsing the site.
Thx
Hi,
I was wondering if it is possible to make an asp page where i get an overview of all the sessionids with its sessionvariables.
Is there an object that I can use to do this ?
Example:
- I have two sessionvariables: Session("var1") and Session("var2").
- Three people are...
You better check if the image has some value instead for being empty (editorjalPic field = Null).
<%
image = CStr(rs("editorjalPic"))
If Len(image) > 0 Then
response.Write("not blank")
%>
<img src="images/editorjal/<%=image%>" width="175"...
If you are trying to Replace a ' you should use
FindString = "'"
Replace(string, FindString, ReplaceWithstring)
If you are looking for the " you use
FindString = """"
'1st " is to open the string
'2nd en 3th " is to get a " in the string...
First you check if there is a record with the same UserName. Is this not the case you insert a new record.
Set rsUser = oConn.Execute("SELECT Username FROM Users WHERE Username = '" & Request("Username") & "'")
If rsUser.EOF Then 'No record found with the same...
You can try to explicitly convert the rs("Cellnum") to a Lng like this:
Select Case CLng(rs("Cellnum"))
Case 66
SmallMachop = rs("Efficiency")
Case 36
SmallAssop = rs("Efficiency")
End Select
or use strings:
Select Case...
If you are not sure about a SQL query you should try it in the database itself. Then you know that at least your query is correct.
Try the following query:
Select * From CUSTOMER where src in (a,b,c,d)
With ( and without ;
Greets
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.