Click here to Skip to main content
15,897,187 members
Home / Discussions / Web Development
   

Web Development

 
QuestionAdvertising on my website Pin
tmoney10110-Sep-06 1:34
tmoney10110-Sep-06 1:34 
AnswerRe: Advertising on my website Pin
James Gupta10-Sep-06 13:22
professionalJames Gupta10-Sep-06 13:22 
AnswerRe: Advertising on my website Pin
Steve Echols10-Sep-06 20:06
Steve Echols10-Sep-06 20:06 
QuestionPlease help, a problem in creating ASP.NET Web Service Pin
Tamatem8-Sep-06 10:46
Tamatem8-Sep-06 10:46 
AnswerRe: Please help, a problem in creating ASP.NET Web Service Pin
Guffa10-Sep-06 21:02
Guffa10-Sep-06 21:02 
QuestionHow to convert any pritable file to TIFF/JPEG/PDF and Text formats? Pin
rajeshrevelli8-Sep-06 8:46
rajeshrevelli8-Sep-06 8:46 
AnswerRe: How to convert any pritable file to TIFF/JPEG/PDF and Text formats? Pin
Walter_H19-Sep-06 4:36
Walter_H19-Sep-06 4:36 
Questionis there any way i can update only some fields in the database excluding primary key ? please help Pin
bobolov8-Sep-06 8:34
bobolov8-Sep-06 8:34 
Error Type:
Microsoft JET Database Engine (0x80040E21)
Index or primary key cannot contain a Null value.
/Poonam/updated.asp, line 73
----------------------------------------------------------------------------
this is my update file


<% dim month, day, year, gender,OStats,DStats,SStats,arrVals,arrAll,rs,usr,strSql,strdes,strinter,strfavm,strquote,strfavs,status

gender = Request.Form("Gender")
month = Request.Form("DOBMonth")
day = Request.Form("DOBDay")

year = Request.Form("DOBYear")

'arrAll = split(Request.Form ("allBoxes"), ",")

'get the array with the id's that were ticked
'arrVals = split(Request.Form ("chkbox"), ",")

'rs("Looking to")= '& arrVals &'
Looking = Trim(Request.Form("ckbox"))
status = Request.form("lovestatus")

OStats = Request.Form("orientationStatus")
DStats = Request.Form("drinkerStatus")
SStats = Request.Form("smokerStatus")
strdes = Request.Form("description")
strinter = Request.Form("interests")
strfavs = Request.Form("favoriteSongs")
strfavm = Request.Form("movies")
strquote = Request.Form("quote")


'Build connection

usr=Request.QueryString("nm")

set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("users.mdb")
set rs = server.CreateObject ("ADODB.Recordset")
'Open record with entered username
rs.Open "select * from userlist where username='"& usr &"'", conn, 3, 3

rs.AddNew
rs("username") = usr
rs("password") = var
rs("fullname") = var2
rs("country") = var3
rs("fld_question") = var4
rs("fld_answer") = var5
rs("fld_email") = var6
rs("fld_visitor_ID") = var7
rs("dd") = day
rs("mm") = month
rs("yy") = year
rs("Status") = status
rs("Looking_to") = Looking
rs("Gender")=gender
rs("Favourite_Quote")= strquote
rs("Favourite_Movie")= strfavm
rs("Favourite_Bands") = strfavs
rs("Sexual_Orientation") = OStats
rs("Smoker") = SStats
rs("Drinker") = DStats
rs("Interests") = strinter
rs("About_me") =strdes

'Save record
rs.Update

set rs=nothing
set conn=nothing

%>
AnswerRe: is there any way i can update only some fields in the database excluding primary key ? please help Pin
Tushar Kothari11-Sep-06 0:45
Tushar Kothari11-Sep-06 0:45 
Questionhow to create a datatable from interop.excel.worksheet? Pin
qahwah8-Sep-06 7:56
qahwah8-Sep-06 7:56 
QuestionFlat Files or Database Pin
Rod Cutler8-Sep-06 6:17
Rod Cutler8-Sep-06 6:17 
AnswerRe: Flat Files or Database Pin
Guffa8-Sep-06 6:59
Guffa8-Sep-06 6:59 
GeneralRe: Flat Files or Database Pin
qahwah8-Sep-06 8:01
qahwah8-Sep-06 8:01 
AnswerRe: Flat Files or Database Pin
Guffa8-Sep-06 8:52
Guffa8-Sep-06 8:52 
QuestionRe: Flat Files or Database Pin
qahwah8-Sep-06 8:58
qahwah8-Sep-06 8:58 
QuestionUnable to acces image after providing querystring params Pin
Sivaprasad C8-Sep-06 0:03
Sivaprasad C8-Sep-06 0:03 
QuestionCan we use web services in classical asp? Pin
Naveed Kamboh7-Sep-06 22:54
Naveed Kamboh7-Sep-06 22:54 
AnswerRe: Can we use web services in classical asp? Pin
RichardGrimmer8-Sep-06 3:01
RichardGrimmer8-Sep-06 3:01 
Questiontrying open a project in web dev express. Pin
uglyeyes7-Sep-06 19:57
uglyeyes7-Sep-06 19:57 
AnswerRe: trying open a project in web dev express. Pin
CWIZO7-Sep-06 21:45
CWIZO7-Sep-06 21:45 
GeneralRe: trying open a project in web dev express. Pin
uglyeyes10-Sep-06 15:40
uglyeyes10-Sep-06 15:40 
Questionrunning visual studio 1.1 and 2.0 in same server Pin
uglyeyes7-Sep-06 15:00
uglyeyes7-Sep-06 15:00 
QuestionIn ASP.NET/CSS make image go to top of table cell? Pin
LuluSailor7-Sep-06 6:21
LuluSailor7-Sep-06 6:21 
AnswerRe: In ASP.NET/CSS make image go to top of table cell? Pin
JUNEYT7-Sep-06 7:13
JUNEYT7-Sep-06 7:13 
AnswerRe: In ASP.NET/CSS make image go to top of table cell? Pin
RichardGrimmer8-Sep-06 3:03
RichardGrimmer8-Sep-06 3:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.