|
Thanks, I solved it already: just put single quote around the string.
what exactly am i trying to do? well, i have this HTML textbox. Data comes from a SQL server and data can contain string with whitespaces. The string is "automatically" truncated when loaded into the textboxes.
anyway, problem solved and case closed.
norm
|
|
|
|
|
Hi all
I have some problem with ASP script.
If someone can help me to point out what I am doing wrong.
Below you can see the code.
It works as follow:
When one click on "Add a customer" button with all fields filled with text, alert
dialogs appear with the text filled in the field and it seems to work fine.
Then I try to open a mySQL database and insert a row with data.
But the alert dialog with text "New customer inserted" never pops up which means
that there is some syntax problem with the statement to open and insert inta
the database. Kan some trace out what is wrong with these line of code.
I have one more question:
As you see that my "myfunction" is written and called in Javascript language.
What changes do I need if the same code for "myfunction" is written in VB and
how to call when "Add a customer" is pressed?
Thanks in advance for your help
regards
/rsasalm
<%@ LANGUAGE="VBSCRIPT" %>
<title>init.asp
Register a new customer
| Namn: | | | Email: | | | Telefonnummer: | | | Rabattgroup: |
professional
Student
unemployed
| | Password: | |
|
|
|
|
|
The code that you showed above is all client-side script. ASP is server-side script.
Try this:
First remove all of the javascript from your page (because it's really not doing anything that you want it to do).
Second, under <%@ LANGUAGE="VBSCRIPT" %> insert this:
<%
Sub myfunction()
Dim name, email, tel, rabbid, pword, DBConn
name = Request.Form("Name")
email = Request.Form("Email")
tel = Request.Form("Telefon")
rabbid = Request.Form("Rabbid") 'Put a name in for the select in your HTML
pword = Request.Form("Password")
Set DBConn = Server.CreateObject("ADODB.Connection")
DBConn.Open("Shop")
DBConn.Execute("insert into tblcustomer values (1,'" & name & "','" & email & "','" & tel & "'," & rabbid & ",'" & pword & "')")
DBConn.Close
Set DBConn = Nothing
End Sub
If Request.Form("B1") = "Add a customer" Then
myfunction()
Response.Write("New Customer Inserted!")
Response.End
End If
%>
Hopefully this will get you on your way.
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
Can anyone explain to me the concept behind tab controls w/ internet explorer. I can handle them in c++ and would like to put them on my website only I have no I idea where to start. I know some HTML and CSS but no scripting languages. I just need a pointing in the right direction, general concepts, etc...Thanks.
|
|
|
|
|
There are actually plenty of ways that you could go about implementing tabs on a web page but it really depends on what you want to accomplish ...
If you just want tabs on your page and you don't really want to learn everything it takes to make them then you could use one that has already been created and shared like the one at WebFX[^].
If you want to dive in and make your own tabs you could use one of these ideas:
FRAMES - should be rather compatable with all browsers. Use the top frame to display the tabs and when one is clicked you change the content in the lower frame.
DIVS - use the CSS attribute display to switch between content when tabs are clicked ... this way all the content can be loaded at once.
I'm sure there are tons of ways to do this ... let me know if you would like further information on any of these ideas.
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
Hi, 
I am developing a project in .NET (C#). I am trying to embed the email sending service in my project. I am able to send both plain and html formatted emails. But i m stuck in trying to get my style sheets and other flashy stuff appear in my html email. Can anyone tell me why my stylesheets and user controls just dont show up in the mail.
I would appreciate if anyone can come up with some suggestions,
Thanx.
Moinuddin
|
|
|
|
|
It's possible items are being stripped out of the e-mail ... can you view the source sent in the e-mail and compare with an original ... somehow ... and check for any obvious differences?
Other than that ... how is the CSS included in the HTML
As a reference:
<link rel="StyleSheet" href="stylesheet.css" type="text/css"> Or an attribute:
<p style="border: 1px solid black;">Message Text</p> If it's a reference it needs to be absolute for it to work in the e-mail.
|
|
|
|
|
Hi Moinuddin,
I think when you draft content that is being assigned to the body property of the mail object, you need to fully qualify the path of the StyleSheet file, with your servername, like http://www.yourservername/yourapp/scripts/style/style.css etc.
Otherwise, you may also copy the required styles inline into the body attribute and proceed.
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
How would I be able to do something in ASP along the lines of:
Application("s") = this Session;
and then later on:
if (Session(Application("s")) != null) ...
I want to be able to check periodically if a session has ended and unfortunately I am not able to access the Session_OnEnd function.
If this was C++ it would be easy, I'd just store a pointer to the Session object in an array in the Application object and then check if it was still valid. But as you know with ASP I cannot store a Session object in the Application object, at least not as far as I can tell. Is there some way to determine if a session exists from an abstracted level, i.e. something like "doesSessionExist(1298347809)" where 1298347809 is the session ID? There must be a way to do this? I'm all dried up idea wise - am I approaching this from the wrong perspective? 
|
|
|
|
|
David Wulff wrote:
There must be a way to do this?
I asked the office and the first response was:
If Len(Session("wally")) > 0 Then
exists
else
doesnt exist
end if
Have not tried or ever done it that way. I like ASP.NET and C#. IT is all an ojbect so checking for null works well. Damned ASP.
Paul Watson
Bluegrass
Cape Town, South Africa
Roger Wright wrote:
Using a feather is kinky; using the whole chicken is perverted!
|
|
|
|
|
I made a cameo in some code!!!
Or is this just of an inflated ego?
|
|
|
|
|
|
Id say that instead of checking for Len...just check if its empty or not..
If Session("wally") <> "" then
exist
else
doesnt exist
end if
GET TO KNOW ME
|
|
|
|
|
Hi everyone.
I have a problem...
I get an error when I want to insert an object into a table. I use asp VBScript and an access database.
The query is as follows: (it works i checked it)
strSql = "INSERT INTO sessionLog (userName, loginTime, sessionID, sessionActive) VALUES('"& strUser &"', '"& Date &" "& Time &"', " & Session.SessionID &", true)"
The recordset opens as follows:
rstSession.LockType = adLockOptimistic
rstSession.CursorType = adOpenDynamic
rstSession.Open strSql, cnnAcc
The error I get is:
Microsoft JET Database Engine (0x80004005)
The operation must use an updatable query(question)
Also tried to use the connection.Execute strSql, rowsAffected same error however.
Anyone?
/Mike
|
|
|
|
|
Ensure that you have write permission on the Access MDB file.
Also, here's the MS help KB[^].
Cheers,
Simon
"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
animation mechanics in SVG
|
|
|
|
|
You should have read/write permission for the directory where the database is placed!!
I was born intelligent
Education ruined me!.
|
|
|
|
|
Hi,
For a long time I have been working around with my C coding in unix. And I didnt really need a IDE for that. I just escaped with the 'emacs'. And for the code maintenance purpose, I prefered the 'diff'. It all went fine until I was pushed to this ASP stuff.
Huh!! I now work around with the ASP/HTML/jscript files. And OMG, I use the notepad. What do I do to see the difference between my yesterdays file and now?? Open the cmd and make a diff there.  I am tired of that now... Can u people suggest me a 'good' IDE for my HTML/ASP/jscript files, to show the diffs atleast? I dont need a complier there  A preview would be better!!
I was born intelligent
Education ruined me!.
|
|
|
|
|
Maybe try VIM[^].
I'm sure they have a plugin for doing windiffs.
At the very least you'll get syntax highlighting.
Cheers,
Simon
"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.
animation mechanics in SVG
|
|
|
|
|
Thanks.... it looks fine!
I was born intelligent
Education ruined me!.
|
|
|
|
|
http://www.textpad.com/[^] 
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
looks cool and good. But lotsa configurations...
I was born intelligent
Education ruined me!.
|
|
|
|
|
|
Thanks ... will give it a try
I was born intelligent
Education ruined me!.
|
|
|
|
|
Hey....
The site html-kit.com isnt going through?? Is that the right address?? I guess the right address should have been http://www.chami.com/html-kit/
I was born intelligent
Education ruined me!.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
