|
Can I upload n download files into database using asp?
can anyone post the smaple code here...
thanks alot...
|
|
|
|
|
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/insert.asp, line 26
<%
' Declaring variables
Dim name, address, age, income, data_source, con, sql_insert
Function ChkString(string)
If string = "" Then string = " "
ChkString = Replace(string, "'", "''")
End Function
' Receiving values from Form
name = ChkString(Request.Form("name"))
address = ChkString(Request.Form("address"))
age = ChkString(Request.Form("age"))
income = ChkString(Request.Form("income"))
data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db1.mdb")
sql_insert = "insert into user (name, address, age, income) values ('" & name & "', '" & address & "', '" & age & "', '" & income & "')"
' Creating Connection Object and opening the database
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
con.Execute sql_insert
' Done. Close the connection
con.Close
Set con = Nothing
%>
bobolov
|
|
|
|
|
I believe user and name are reserved words.
Try [user] and [name] instead and see if it helps, everthing else seems ok to me.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
I have a site on my computer that i am working on, using asp.net as my front end and sql server 2000 as my backend. I am trying to let someone view my site over the internet. Can anyone help me to achieve that? i am connected to the internet via a wireless connecting, where i am recieving connection from my friend who is on dsl connection.can anyone help me.
Nab
|
|
|
|
|
You must buy:
1- domain name
2- Hosting support with ASP.NET
when you have a server you can upload all webpages into your server.
and test your website:
Ex:
http://www.yourdomainname.com
-------------------------------------
From: Hy Chanhan
I am a student at BBU in Cambodia.
In major: Information Technology.
This web is so interested.
|
|
|
|
|
Hy Chanhan wrote: You must buy:
1- domain name
2- Hosting support with ASP.NET
when you have a server you can upload all webpages into your server.
and test your website:
Ex:
http://www.yourdomainname.com
Utter UTTER tripe....
All you need to access ANY machine worldwide is an IP address (Firewalls permitting of course)....
To get someone to see your site, make sure firewall is configured to allow incoming traffic on port 80 (**PROBABLY**), then if you use http://localhost/mySite/Default.aspx, then just replace localhost with IP address of your machine and the port number if not 80 - like : http:192.1.1.1:80/mySite/Default.aspx
That should allow people to see your site OK - although Hy Channan is correct from the point of view of a commercial site, for just showing someone, there's no need for the expense (And even then, there are plenty of FREE ASP.NET / SQL providers that will give you a free sub-domain)
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Does anybody know how to implement a dialogbox brought up by the Web Server? This is useful in cases where the server needs to inform a client that a certain condition has changed. Thanks!
|
|
|
|
|
Yu have to use client side code to do this - usual method is to code the dialog in HTML, put in in a DIV, then manipulate style.display and / or style.visibility to show and hide it....
If you ask the server to show a dialog / message box, it will - ON_THE_SERVER 
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
I think the title says it all. I have been very successful playing around with an ajax sample to get it to retrieve a string from a web service, but i cant seem to figure out how to pass a variable to the web service, which would obviously limit it's usefulness.
Does anyone have any suggestions?
______________________
Mr Griffin, eleventy billion is not a number...
|
|
|
|
|
Browse to the web service, and it should show you an example of how the input should look like. At least if it was developed using .NET.
---
b { font-weight: normal; }
|
|
|
|
|
If you're using pure Javascript, then it ain't no fun...you'll need to look at the WSDL to see what parameters etc are used.
There is somewhere on CP a js class that abstracts out the difficult bits, and just allows you to call a asmx from JS without much difficulty. Can't remember where though!
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Hi
I have been asked to monitor what websites employees in my company visit during work hours.
I had a program that I found from The Code Project, but it no longer seems to be working when used on one of the PCs, I need to be able to view the results as a web page.
Can anyone suggest anything that could work?
Cheers
|
|
|
|
|
can anyone show me a link to a tutotial of incorporatig audio streaming with web page?????????
i want to connect to a remote server via a website page and search for an audio files and then use the website to play the file via streaming
kenny
|
|
|
|
|
Hi.
I have a web service that needs to replace files. However, when I do this an Unauthorized exception is thrown.
I can't figure out how to do this. I'm running the client program and the service on the same computer.
Thanx for any help.
|
|
|
|
|
Here is a small test for all those hardcore JavaScript programmers. Is it possible to drag'n'drop a text/image element (eg. A or IMG tag) from one (I)FRAME to another (I)FRAME. This is easy & possible with IE's proprietary ondrag events. However the question is, is there a work-around using standard W3C/Firefox onmousedown, onmouseup, etc. events only?
For an example of drag'n'dropping from one FRAME to another (using IE's events) see:
http://www.tardis.ed.ac.uk/~afsweb/dndp/default2.html
You can download all the files at:
http://www.tardis.ed.ac.uk/~afsweb/dndp/dndp.rar
|
|
|
|
|
Have you used Google's personalized homepage? You can drag and drop on that page to move around your modules as ou wish. I've always meant to View Source and see if they used javascript or what...you might check it out and see how they did it...
"Half this game is ninety percent mental." - Yogi Berra
If you can read thank a teacher, if you can read in English, thank a Marine.
M y and h don't work so well due to m addiction to caffeine and m in abilit to to set a cup down uprigt.
|
|
|
|
|
So it's official, Mozilla Firefox cannot and will never be able to do drag'n'drop across (I)FRAMEs - just like MS IE. Drag'n'drop ability is a must for Web Applications that want to be similar to native Windows Applications based on Multiple-Document Interface and letting users drag'n'drop from one child window to another.
|
|
|
|
|
I bet this can happen with AJAX. I haven't devled into the AJAX world yet but I plan too soon. As far as I can tell, AJAX allows desktop-like interfaces in web applications.
"Half this game is ninety percent mental." - Yogi Berra
If you can read thank a teacher, if you can read in English, thank a Marine.
M y and h don't work so well due to m addiction to caffeine and m in abilit to to set a cup down uprigt.
|
|
|
|
|
I have a calendar and when i click the week number the whole week should be selected and also when i click the month the whole month should be selected and the month scheduler should come up while the day and the week scheduler greys out.Any one at a time like the google calendar.
|
|
|
|
|
Hi all,
Is there any way to find out which server has responded to the client request out of all the servers in an Application Center cluster.
Awaiting reply
Ramesh.Kanjinghat
|
|
|
|
|
Hi!
I'm calling a personal web service from a c# app and when the web service tries to save a file I get this exception:
'System.Web.Services.Protocols.SoapException' at system.web.services.dll
Additional info: System.Web.Services.Protocols.SoapException: The server can't process the request. ---> System.UnauthorizedAccessException: Access denied to the path.
The path that it tells me actually exists as is. I've tried to move it, change things in web.config (tried the "imperonate" option) but I can't make it work.
I'm actually accessing the web service on localhost and still crashes.
Need help, please.
Thanx in advance for any.
|
|
|
|
|
It sounds like you have a permission issue.
Try giving a write permission to your ASPNET account (or whatever account you're running your web service as) on the folder you want to save the file to.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
|
If you're using Windows as your OS you can open Windows Explorer, right-click on the folder you want to save the file and choose Properties. Go to the Security Tab, and then add ASPNET (or the account running your web service) and give it a Write permission.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
There is no security tab O_o?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
