How Do You Make If.then.else Do Two Stuff On One Line?

is it possible to do a insert, add, and a redirect all on the same page?

for example... signup.asp. there's a text box labeled Acctid. If you don't have an acctid please enter "0000" otherwise enter one. This box is used to see if they have an existing account in the database by using an UPDATE query and if they don't it does an INSERT query with acctid = 0000 for all non customers. What I want the if.then.else statement to do is to

If acctid = "0000" then
conn.execute acct_add
(and if sucessful to response.redirect "/yay.asp"
Else if NOT acctid = "0000" then
conn.execute acct_update

(but I want it to return an error if the update wasn't sucessful either because the acount doesn't exist or watever and if the update was sucessful to response.redirect "/yay.asp") END IF

Do ya get it?

View Replies


ADVERTISEMENT

ASP, XML Stuff...

I'm trying o get my head around XML and using ASP to parse documents.

I've managed to kncok together the code below to send a request to an
external server and then pop the response into a variable and format it
a bit.

What I'm trying to do is insert the data into a nice HTML table, maybe
using the node names as column headings. Has anyone got any suggestions
on how I can do this? and also, is this the best methid of performing
this task? I need it to be xbrowser compatible so I figured server side
would be the best option. Code:

View Replies View Related

Textarea Stuff To A DB

I've written several scenarios where the end user needs to enter data into a textarea (descriptions, messges etc) which becomes part of a form. End users often put apostrophe's and carrige returns in the textarea... however, when the code i write is submitted to the database, it generates an sql command from the page that sent the action.

Client Side:

<form action="somepage.asp" method="post">
<input type="text" name="emailaddress">
<textarea cols="20" rows="5" name="comments"></textarea>
</form>

On code submission...

sql="insert into tableName (email,comments) values ('" & request.form("emailaddress") & "','" & request.form("comments") & "');"
db.execute(sql)

Now, when strange people put carrige returns, it stuffs up the string and therefore produces an error, and to make matters worse if it did recognise a carrige return, it wouldn't be displayed on HTML output. Apostrophes are even worse - they signify the end of a variable in the SQL sentance Can anyone help me and figure out a new way of writing to the DB?

View Replies View Related

Dates And Stuff

I'm gonna be writing a new ASP based system for work for staff to book in deliverys with our warehouse - I'm starting to think about the database design and i'm trying to think how best to work it - Each day will be a record - with a date field - but I have no idea how to automatically create a date field with concurrent dates - and also we can book deliverys upto 6 months in advance, so there needs to be a lot of records created.

View Replies View Related

Date Stuff

<%
dyear = year(RS("dates"))
dmonth = Month(RS("dates"))
dDay = day(RS("dates"))

response.write dyear
response.write dmonth
response.write dDay
%>

i get 2003 12 9

how do i dispaly 2003 December Tuesday

View Replies View Related

Forms, PHP, ASP 'n Stuff

I have a web form (fine so far) which POSTs to a PHP routine which mails the information. Very standard. Now I would like to update a database as well as emailing the form contents.

The problem is that the database has to br MS SQL and I can't install the bits to make it work with PHP - so the database part HAS to be ASP. The mail bit HAS to be PHP as that's the only mail routine I can use. Code:

View Replies View Related

Photo Album Stuff

I am about to get rid of TZO on my computer, and I've been using it's photo software to view photo's on my web site. I could write something in ASP (or asp.net), but I figure why spend time re-inventing the wheel if there's something already out there.

Does anyone have any recommendations on ASP apps that I can use for viewing photo's on my web site? I would rather it be free if possible, and it needs to just look at a folder, or series of folders, and build a thumbnail type of view from what's there. In other words, I don't want to have to populate a database with all of my pictures.

View Replies View Related

Loading Stuff Into Combobox

I have a combobox that on page load is disabled. I've noticed that the information will not load into the combo box if this is the case. Is there a way to load the information and then disable it so the user has no idea what has happened? I load another combobox before this one, that is NOT disabled and so loads properly.

Code:

="1" name="County" disabled="true">
<%
While not objrs.eof
%>
<option value ="<%=objrs("County")%>">
<%=objrs.fields("County")%>
<%
objrs.movenext
wend
objrs.close
%>

View Replies View Related

Read Cell Data Line By Line From Excel

I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)

Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?

View Replies View Related

ASP Equivalent Of Some Cold Fusion Stuff - Date/Time?

I was wondering if anybody could help me translate this from my native Cold Fusion tongue to ASP? :

#DateFormat(Visitors_DateTime, 'dd mmmm yyyy')#
#TimeFormat(Visitors_DateTime, 'h:mm tt')#

The data is held with SQL2000 in a smalldatetime datatype column.

Would just like to display the full date and time really.

View Replies View Related

Read Txt File Line By Line

I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.

Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?

View Replies View Related

Make A DLL

How can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?

View Replies View Related

Make A Form

Hi does anybody know if you can make a form
have two actions and how?

View Replies View Related

How To Make 1000000 Looks Like 1,000,000 ?

how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.

View Replies View Related

Make Link

when you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.

View Replies View Related

How To Make OCX Talks To ASP

Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?

'script block

<%
dim myObject

set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)

%>

'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>

View Replies View Related

Make Match

I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.

View Replies View Related

Make The Pop Up Info Box

When you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.

I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.

View Replies View Related

How To Make The Session

how to make the session timeout. and where should i put the session timeout.

View Replies View Related

Make Support ASP

I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.

Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.

View Replies View Related

Make ASP Page

I have a webapp. that holds a lot of documents. Some of the documents needs to be produced from a database on-the-fly, some are static documents like PDF, Word documents, etc... In the end, a user can do a request to produce a large amount of documents as one huge PDF document. Today the creation of documents is working, but all code is done in ASP.

In Visual Basic, I was thinking about making an ActiveX EXE server that generates the PDF document. The ASP page will be polling until the file is generated. When this is done, the file will be displayed. I have only written down my thoughts on the subject. Is there a good way to do this?

View Replies View Related

Make Html Off

how to off the html in the textarea or text box. so if user write an html code in textbox or textarea , would.nt make the page changes. like this add thread how about if i wrote an html like </table>, it will make the display page change.

View Replies View Related

Is It Possible To Make A Cookie NEVER Expire?

Is it possible to make a cookie NEVER expire? or not?

View Replies View Related

How To Make Checkboxes From Database

How to use asp to populate checkboxes from a column in an Access table? I want them to be updated when the table is updated.

View Replies View Related

Trying To Make Secured Pages.

I got admin's pages and users pages. If I haven't logged in as an admin first and i'm either not logged in at all or logged in as an user then when I try to enter an address of an admin's page then it redirects the user to the main page.

I tried solving the next problem with cookies andor with session but neither of them worked. Code:

View Replies View Related

To Make Hyperlink Clickable

i have this

Response.Write Replace(Rs("Event_Details") & " ", vbCrLf, "<BR>") & vbCrLf

coming from access db.

how can i get that to make a hyperlink clickable as well??

View Replies View Related

Make Access Forms Available On The WEB

I am looking to make my company's access database (forms, reports, etc) available through a web server. Any idea what type of programming will be needed (ASP, JSP, PHP)? If there is anyone that can help me with this please let me know. I am willing to compensate them for their time and help. It should be a fun project.

View Replies View Related

Where Do I Start When I Want To Make My First ASP Database?

I would like to make a database that contains Picture, Name Job description, gender and web address. The database should be able to hold at least 1000 profiles.

What program would you sugest? Where do I get it? Are there any online tutorials you would suggest?

View Replies View Related

How To Make A Page Look Like It Is On Another Site

I am developing an ASP page for clients. I will host the page on my
server, but it must appear on the clients' websites. That means that
the user should not be redirected to my site, but instead should remain
on the client's site. Or at least appear that they are remaining on the
client's site.

One thing that would be acceptable is to host the page on the client's
site, but have it hit my site to get the data. I have looked into
XMLHTTP and also just having the ASP page hit a remote SQL Server
instead of a local one, but haven't made any decisions yet.

View Replies View Related

Make Timer! ASP & Javascript

i know little about javascript and i am trying to make a timer for some exam. i know how to take the value from the table but i dont know how to show that in the form and make it move from the time eg. 00:10:00 until 00:00:00 and stop the exam and go to a different page which will have the results. i just need to know how to populate the time in
javascript?

View Replies View Related

I Have Some File Want To Make A Web Server

i creat one sql server and want another computer on my lan run my web server (i mean the computer on lan can insert data and store to my sql server)but i don't know to do that .i used windows 2003 and IIS6.

View Replies View Related

How To Make New Page Open As A Pop-up

I have a page where the user selects the product they want and from that selection a new page opens with a detailed look of the product. I would like this new page to open as a brand new window with a size I have choosen. Where do I set the size I would like to the page to open as?

View Replies View Related

Make Your Own Site & Editor

I have a preatty cool website builder and editor. It alows the user to make pages, edit, and delete them. It also makes the navigation bar for the user automatically. You can even change the colors, your user id, password, secret question, and more.

The editor allows the user to use an editor like the one here on sitepoint. I was wondering, are there anymore features in asp that I could add? Any suggestions would be greattly appresiated. By the way, I am using a database, I believe it is access 2002, not sure, but I do use a SQL statement to connect to it.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved