|
after careful reading of code i came up with those issues,
i think the problem likes sum where in here
while converting a text area field
------
Case "textarea"
strFormValue = Server.HtmlEncode(strFormValue)
strFormValue = strFormValue.Replace("""","&" & "quot;")
strValues.Append(",""" & strFormValue & """")
---------
which produces this insert query
INSERT INTO profiles (CreationDate,ModificationDate,ImageName,ImageCaption,
UserName,Password,Email,GenderID,Age,SexualOrientationID,EthnicID,
Height,BodyTypeID,NeighborhoodID,AboutMe,WantActivityPartner,WantFriend,
WantDate,WantLTR,ForwardMessages,SignID,ActivationCode)
VALUES (DateTime.Now()),DateTime.Now(),NULL,NULL,
'hello',MD5('cocacola'),'bikash557@hotmail.com',2,23,1,2,49,2,2,"i not not me",1,1,1,1,1,1,"tq45z3xlg5554f34")
both "i am not me" and the activation id should've been inside single comma and i dont know if MD5 works in sql server 2000.
any idea any one please help me.
thanks
i am still trying to know how to catch fish.
|
|
|
|
|
foremorecoast1 wrote: i think the problem likes sum where in here
while converting a text area field
------
Case "textarea"
strFormValue = Server.HtmlEncode(strFormValue)
strFormValue = strFormValue.Replace("""","&" & "quot;")
strValues.Append(",""" & strFormValue & """")
---------
Yep - you're on the right track. Good luck.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once 
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
i tried hard spend almost few hours i realy dont know whats wrong with that code and MD5 doesnt work too. i am really at lost.
|
|
|
|
|
Try MD5_STRING() instead of MD5()...
Also, replace the double quotes in your statement with single quotes....
Let me know if that does it...
-Kay
|
|
|
|
|
i tried the above code with
----------
Select Case strFieldType
Case "text"
strValues.Append(",'" & strFormValue & "'")
Case "password"
'Use 128-bit encryption.
strValues.Append(",('" & strFormValue & "')")
Case "textarea"
strFormValue = Server.HtmlEncode(strFormValue)
strFormValue = strFormValue.Replace("''","&" & "quot;")
strValues.Append(",''" & strFormValue & "''")
Case "number"
strValues.Append("," & strFormValue)
Case "checkbox"
If strFormValue = "on" Then
strValues.Append(",1")
End If
End Select
-----
but i still get this error. and md5_string doesnt work so i wont bother encrypting the password please help .
many thanks in forwad.
|
|
|
|
|
finally its working but my MD5 is not working. i tried md5_string but no help. is it okay if i leave the password unencrypted whats wrong with that?
|
|
|
|
|
So how did you fix it? For everyone's knowledge?(besides the encryption).
-Kay
|
|
|
|
|
It's really only a problem if someone gains access to your database. Then they could gain access to any user account since the user name and password are in the table in plaintext.
Encrypting the password at least makes it much harder for any hacker to get access to anyone else's account.
MD5() and MD5_STRING() arn't working because they are not TSQL functions. You can't use it in the manner in which you've coded it.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|
|
When I try to update modified rows in an access database I get the following error
"Update requires a valid UpdateCommand when passed DataRow collection with Modified Rows"
I am using a VB2003 Dataform to enter and update my DB. Any ideas on ehat might be wrong?
|
|
|
|
|
It was a problem to me. First check whether you created the Primary Key.
chatura
|
|
|
|
|
Hi All,
I am fairly new to VB.NET however, I am working with Drawings, and have encountered a problem. Whenever I try to draw a line outside of the original size of the form it does not appear. For example a form 300x300 even when resized prior to execution still will not allow a line outside the 300x300 area? any ideas?
Regards,
Oz
|
|
|
|
|
Hi
Is it possible to use my VB application to run Summary Reports from a Database at a click of a button.
Basically, I have a Database Table with 3 Fields - Date, Task, Duration.
I want my VB application to produce Summary Reports based on the Data in the Table at a click of a button. I want to be able to produce Daily, Weekly and Monthly Reports.
Is this possible? Please let me know if more info is needed.
Regards
ensuvari
|
|
|
|
|
yes u can do so with the help of datareports or crystal reports whatever u want to use in ur application. with the help of these reports u can generate any kind of report on a click of button
|
|
|
|
|
Do you know any links to online Tutorials where I can learn how to use DataReports and CrystalReports?
Regards
ensuvari
|
|
|
|
|
|
I am reading in an image (JPG) and I need to change the DPI from lets say 96 to 72. Here are the last two lines of code I am using to create the new image.
bmTarget = New Bitmap(ResizeWidth, ResizeHeight, PixelFormat.Format24bppRgb)
bmTarget.Save(NewPath, Drawing.Imaging.ImageFormat.Jpeg)
|
|
|
|
|
To fix the DPI of the image here is what I ended up doing.
After I created the bitmap image I used SET RESOLUTION -
BMTarget.SetResolution(intDpiX, intDpiY)
Then save the image
|
|
|
|
|
Hi
Just starting to look at .NET 2.0. Is it possible to get hold of the Application Event instance from anywhere in the application, guess it must be like a singleton?
Cheers
Rich
|
|
|
|
|
hi there all,
I am having a hard time doing this, the sample code is like this
Dim p As New Process
p.StartInfo.FileName = "C:\windows\system32\runas.exe"
p.EnableRaisingEvents = True
p.StartInfo.Arguments = "/user:myuser@mydomain notepad.exe"
p.StartInfo.UseShellExecute = False
p.StartInfo.RedirectStandardInput = True
p.StartInfo.RedirectStandardOutput = True
p.StartInfo.CreateNoWindow = True
p.Start()
Thread.Sleep(1000)
p.StandardInput.Write("mypass" & System.Environment.Newline)
p.WaitForExit()
p.Close()
p = Nothing
I was able to run services like this, doing other stuff from command prompt inside my application. but as runas require password which am trying to enter but it is not working.
|
|
|
|
|
I have a custom control that I created. It's a multicolumn combobox. It works great. My only problem is that I can only use ONE on my form. When I add a second instance of the control it will not do anything....only ONE will work. Anybody have an idea why that is?
-Kay
|
|
|
|
|
i'm using mshflexgrid control
i am using this for adding row
grid.additem (grid.rows)
and showing the textbox contents in the grid usng the row and col properties
for removing a row i'm using this code
grid.removeitem (grid.row)
but after deleting a selected row (user selects), adding a row using the above code adds the row but doesnot show it in the grid
please help ...its urgent
|
|
|
|
|
y dont u try to do this with .textarray prperty ., I think it will help u more efficiently than this.
for further details u can ask bcoz i'm using MSHFlexGrid in my codes also
|
|
|
|
|
Hi to all
can someone help me in writing code for Hibernating and Stand By (suspend) computer using vb.net code.
I have searched the internet a lot but don't found a reasonable answer to it.
|
|
|
|
|
I think but im not sure you will have to double check it
that there is some functionality in wmi. there is good documentation on the
microsoft website on how to access wmi from vb.net
good luck.
Dan
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
