User Inserted
I have a form where people from around the world will enter their address. As you know, addresses from around the globe vary so darn much. I thought that instead of a form with text boxes for such things as city, zip, street 1, street 2, etc., I could use a text-area. That being said, if someone entered in an address in a text box such as this:
Joe User
121 E 209th
Euclid Ohio
44123
United States
Could I take that and on the insertion into a database insert a <br /> where appropriate?
View Replies
ADVERTISEMENT
I have an oracle database that I am submitting a form to. In the database I have setup a trigger to insert a casenumber everytime a form is inserted into the database. After they submit the form I then want to display to them the casenumber so they can check the status later. My problem is returning the correct casenumber to the user. Currently I am returning the max value from the casnumber column, but I think that may cause problems.It is working right now and gives me the correct value, but will I run into problems if 2 people submit a form at the same time? If you don't think this will work, what would you suggest I do? Is there anyway to return the value from my trigger?
View Replies
View Related
Im using a ASP and MS Access 2000 database. What im trying to do is: I insert a row into a table, in that table is a field that auto increments. after I insert this row I want to immediately after that be able to retrieve the value of the column containing the auto increment and hold it in a variable so i can use it for other things.
can anyone help me with this? I have been messing around with SQl cursors but cant seem to get it to work right.
View Replies
View Related
The problem is that all the tuts I find on hits do the insert and connection so differently I am lost!
My code so far:
Code:
Dim rsBOR, inBOR, insSQL, newID
Set inBOR = Server.CreateObject("ADODB.Connection")
Set rsBOR = Server.CreateObject("ADODB.Recordset")
inBOR.Open Application("strConn")
insSQL = "insert into Main (EventName, .., RegionID) values ('"& strEventName & "',..,'" & RegionID & "')"
inBOR.Execute insSQL
' Retrive the ID
newID = inBOR("EventID")
Response.Write "The Event has been added to the database"
inBOR.Close
But it just doesn't like it!
Any ideas on how I should go about this?
View Replies
View Related
I'm using mySQL and wanted to get the ID of the record that I have just inserted in to the table (sentmessages). There is a function in mySQL that appears to be able to perform this task but I am not having any luck in getting it to work.
Anybody else tried, successfully or not, to use this ? The function is called LAST_INSERT_ID() and I have tried to implement it as follows :
strLastID = objConn.Execute("SELECT LAST_INSERT_ID() FROM sentmessages") .
View Replies
View Related
That error is this:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/noticias/indexnot.asp, line 45
In line 45 I have this stretch of the complete code below.
RS5_Tema(Aux) = RS5("auxcategorias")
The problems in codigo had started later that I added this code more. Code:
View Replies
View Related
I have to tables related to eachother,
like for example
an Emlpoyee table which has an Auto Number as primary key and as the ID of the employee.
And Employee_Phones which has 2 fields the Employee's ID and the phone number field.
when I insert a new record in the Employee table, I want to insert multiple records related to it in the Employee_Phones table.
After inserting a record in Employee table I want to retrieve the ID, then use that ID to insert other records in Employee_Phones table.
Is there a command of function to return the ID of the inserted record, Or do I have to query the database again? I've loked for a function or a method but I didn't find any?
View Replies
View Related
I don't know if anyone has encountered this before. I've written ASP code to insert, update and delete records from Access and SQL Server tables before but this is the first time I face this issue -
I have a form that inserts data into an Access table. For a few of the fields, commas are getting inserted into the table. If the field is left blank, there is a comma inserted. If we enter data in the field, the comma is appended to the field value (eg: smith, )
The only thing different that i'm doing here from what I've done before is I'm inserting a larger number of fields into the table - 117 fields!!
Do you think the insert statement hasn't been written correctly?
View Replies
View Related
iwana code with aspwho can help me?think that i make a interface which with sql sttement lsted all the records in the one table.another one at that time inserted a new record.so iwanna have a cod that listedrecords (when that record was inserted) and i see all the record(cotain the new record) again.plz help me and show me a code.my mail is kianoosh_ardavan@yahoo.com
View Replies
View Related
When I insert a record into my database, I don't insert the ID field because it's an autonumber and I want the database to generate it right?
Here's my question: Is there a way to have the recordset return that ID, or some other way of getting it with out making another recordset to grab the ID of the record that I just inserted?
View Replies
View Related
I am using ASP and SQL server 2000.
I insert reocrd using Insert query.
I want to get value of last inserted record in ASP for SQL server.
How i can get it?
View Replies
View Related
I have a form to submit a record to a database and immediately after it's submitted I want to send an email with a link to that record. How can I retrieve it's ID (which is an autonumber) from the db to write it into the querystring of the link?
View Replies
View Related
when I ourput data from Access, numbers bigger than 999 are shown with letter "B" inserted into the 4th position left to the coma. (in my w2k regional settings I have the decimal dot separator set to "." and digit group separater set to nothing. In Access the number are shown with "." as decimal separator, but for some reason ASP used "," instead)
Say, 3000,00 is shown as 3B 000,00 Why and how do I sort this out?
View Replies
View Related
i have a problem with my asp code...when i run a query, i insert the results on a temporary table...everything works fine except when i try to load the result page, it doesnt not display the recordset...
i need to press F5 always so that the page will be refreshed to show all records in the table.. how can I retrieved all inserted records in the temporary table without reloading the page?? below is my result page... Code:
View Replies
View Related
I'm UPDATING a value into an Access text field from a page but I can't get it to do the UPDATE without adding a leading space to the value??
This is a problem because I have another page where a user can search the entries, but when they do a search by this particular criteria, it returns no entries (ie. Search good_bad by "Positive" returns no results, but Search good_bad by " Positive" will return the proper results).
The value is coming from a option select box. It seems to only be a problem doing an UPDATE using a value from a select box as I'm using the EXACT same code to do an INSERT where the value comes from an INPUT box and it inserts with no leading space?? Code:
View Replies
View Related
Without writing a bible on what I'm trying to do I'll see if someone
can answer a quick question.
I have a form that the user writes a value in a test field. I need to
put a hidden value that will take the same number the user inputs and
insert it in a form.
Basically, I need ...
<input name="hdndkqty" type="hidden" id="hdndkqty" value = ??? />
the value of the hidden field to = <input name="num" type="text"
id="num2" />
View Replies
View Related
sql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
View Replies
View Related
I have written an ASP.NET 2.0 application that uses Active Directory or ADAM
to manage account users - the site has a page that allows people to create an
account (much like any site). The page populates the AD with all the
information and the user account but I am unable to enable the account.
Microsoft has information on how to do that here -->
http://msdn.microsoft.com/library/d...ting_a_user.asp
(the sample is for Visual Basic) - and I am unable to complete the bottom
portion of the script. Can some one point me in the right direction - or can
you tell me how I can add a snippet of VBscript code to an ASP.NET page.
I am using the Active DS Type library - not sure why there are multiple ones
(System.DirectoryServices) but it is rather confusing - I seem to accomplish
one thing with one and another with the other (they did have trouble
co-existing however). Anyway my script works very well but I am not able to
access the properties required to enable the account.
Here is a simple version (no error checking) of the code.....
View Replies
View Related
how to go about setting up an asp script or flash action script to take the input from a user of his/her username and password then send an email to the user with the information. I am able to do all of this but the problem is that the users pc is the one sending the email. I want the server to send the email instead.
View Replies
View Related
I'm having a real tough time getting a User's NT login after they
submit a form.
I have Anon. Login disabled. I'm using Digest Authentication (although
I've tried everything).
Every time I run the page, I get a blank string instead of the
requested information.
The information is in a hidden field, with the value set to:
<%=Request.ServerVariables("LOGON_USER")%>
The icing on the cake is that when I run this on my PWS, I can pull the
information and it shows up in the SQL DB I'm sending it too. But, when
put on our live box, it doesn't show up. The setting on each box are
exactly the same.
View Replies
View Related
I have a classic ASP program running on a server in the DMZ. I need to consume a web service so that I can consume data from that web service. However I am not able to call the web service from the DMZ since the server can not send messages out on the
internet.
Thus, I need to send the call to another server running within the internal
area of the company's internet. I need to send this message to an IIS server
and then from the IIS server call the web service. I was thinking that I need
to call the service on the IIS server with an ADO.NET connection. This
ADO.NET connection object would be generated just long enough to call the web
service, get a response from the web serice, and return the message to the
server running in the DMZ.
Let me know if you think this would be a good solution and tell me how you
would setup this interface. (Should C#.NET or Visual Basic.NET be used or
some other lanaguge.)
Also after this solution works, I will need to implement this similar type
of solution to call other web services.
View Replies
View Related
does anyone know a way to show a users USER name instead of just there login name
its for a school intranet currently we retrieve a lot of data based on the login name by using this script:
[code] <%=Request.ServerVariables("LOGON_USER")%>
it would be a lot more functional if i could pull the full name, we are using Active Directory 2003 and iis6, and all the logins have the full username inputted in the AD?
View Replies
View Related
It seems that the ASP.NET user in AD has been deleted. How can I get it
back?
View Replies
View Related
I'm developing an ASP form registeration system. The details of the form must be added to a text file not the tradional database.
Each time a new user adds a record it should be added to the list at the bottom to the previos adder.
Does anyone have a script sniplet of how i could do this.
Remember details from the form i.e. name, firstname should be added to a text file...
View Replies
View Related
How can I get the user information of the user as which the ASP script is being run?
View Replies
View Related
I am new to .NET and I am trying to get the user name from a kerberos ticket and I have no idea how to do that. There seems to be some ability to do it using WSE 2.0 but I cant really see why there is not an easier way. how to do this?
View Replies
View Related
I have a admin-page wich is username and password protection and Microsoft Access database with table called "member" and fields "username and "password" in it. I wan't to have a welcome message when user is successfully logged in so he/her can see for example "Welcome Chris". How to I do this?
View Replies
View Related
I'm running IIS5 on a Win2K server, and I want to have an ASP page that
creates new users. I have some simple code to test this, but am getting
a "500" error when I run it. The ASP looks like:
<%
strDomain ="Foo.com"
strUser ="Foo1"
' Create new user with password
Set oDomain = GetObject("WinNT://" & strDomain)
Set oUser = oDomain.Create ("User", strUser)
oUser.SetPassword = "password"
oUser.SetInfo
%>
Just for this testing, I've added IUSR_machinename to the Administrators
group, but am still getting the 500 error.
View Replies
View Related
How can i limit the number of users on my .ASP page, i want only one user to
be using the page at a time,
The query i have on my page is big and takes a lot of my system resources.
View Replies
View Related
I have a login page. and more users. Let's call them users A, users B and Users C. Users A can only access page A, users B page B, ... All the pages uses the same DB, but different tables (table A, table B, table C).
View Replies
View Related
I surveyed 1000 people and 884 of them said that they prefer forms that are filled out in sections (multiple pages) instead of one long form. I am trying to do that with my site. Currently the way I was planning it was:
register.asp - sets up username >>
stage1.asp - checks for unique username >>
stage2.asp - personal info >>
stage3.asp - more personal info >>
stage4.asp - even more personal info >>
stage5.asp - yet more personal inf >>
stage6.asp - employer info >>
stage7.asp - Finished
When users go to register, I want to:
select a user name and password, then make sure the user name isnt taken, make sure the passwords match, collect personal info over a few pages, then finish.
I would like to do all this only utilizing the register.asp and possibly a process page. Anyone have any links or tutorials on creating pages like this.
View Replies
View Related
Do you know how to get windows login variables (i.e. the LOGON_USER server
variable) from ASP without having to fill in the challenge response message
box that automatically appears when you configure IIS to Integrated Windows
Security for a particular site? I don't want users to have to log in again
to the site as they have already logged in to windows but I want to use
their username on the back end to verify permissions. Is it possible?
View Replies
View Related
I'm facing a situation where my team leader wants me to create some ASP code that will pull the user's ID (which is no problem - request the LOGON_USER server variable) and THEN pull that user's NT Permissions to determine what kind of permissions the user will have when he/she comes onto the website. There is to be no logon screen at all. The permissions cannot be determined via a database or through cookies. Only NT Authentication can be used.
I have a small hunch that the HTTP_AUTHORIZATION server variable might provide a clue, but the value of that variable is a bunch of (encrypted?) gibberish that means nothing to me, except probably the NTLM part at the beginning. Is there a way to decode the value of that variable into something coherent that I can use in my code?
View Replies
View Related
