Hi,
I have an SQL update based on the value of the checkboxes:
SQL="Update Table Set Status = " & CInt(Request("chkStatus")) & " Where ID = " & IntID
But I couldn't get the value of the checkboxes. I always update with checkbox's value = 0.
Here is my...
Hi,
When I tried to insert a value with a postrophe, it became "" in my table.
name= Kelly's Pan
strSQL="INSERT INTO mytable " & _
"VALUES ('" & name & "','" & email & "') "
How can I avoid this and still doesn't effect other values(without...
Hi,
I have a group of radio buttons in page1. When user click submit, if one of the button is not selected, I want to display a msg to tell user must select one to move on.
I have some thinf like this but it didn't work (let user go to next page)
<input type="radio"...
Hi,
Please help me with thsi easy one, I forgot the systax:
I page, I want to set the session var = value of a drop down box.
Then I want to set the text box of the next page euqals to this session var.
I try something like:
Session("Val")=Request("DDBox") (DDBox is the...
I'm about to setup an encryption page for my web site but I don't have any clue about this. Do you have any sample code or any link that I can look up?
I've heard something about "https" but don't know exactly what it is. After users enter their Creditcard info, they want their data...
Please take a look at this code and tell me what it does?
If there are 2 records with the same fieldx & fieldy, will they be remove both or just one?
Thanks.
-------
declare
@fieldx char(5),
@fieldy char(5)
declare the_cursor cursor for
select fieldx,fieldy
from Table1
open...
Hi,
How do I do a query that will return common records from 3 tables which have 3 fileds match. I've tried the inner join inside another inner join but it gave me error.
Thanks
Hello friends,
Please help me to make this complicate query:
I have 3 tables and want the records return from the first table with these conditions:
1. table1.id = table2.id = table3.id
2. table1.code = 4
3. table1.income > $10,000
4. table3.xcode =2 or=3
Here is what come up with...
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.