Sql Function Options

My Current project requires the use of ASP.I've been able to pick it up fairly quickly, but I'm curious to know if there is a function similar to the php mssql_num_rows().
This simply returns the number of rows returns with your specified query. So far my search through this forum hasn't returned anything of the like.The closest I have seen would be to execute another sql statement to count the result first. Which seems to be alot of double work.

View Replies


ADVERTISEMENT

My Options

i thought id post it and see what more experienced people think. With firefox now the browser of choice with people in the know their lack of VBScript support is causing me problems. If i want to say validate my forms i must now do it on the server-side (which is probably safer anyways). But things like pop-up warnings ??? or if i want to perform _OnLoad, _OnClick, _OnChange events , what do i do ?? or more to the point what are my options if any. What is the general opinion on using VBScript with ASP pages.

View Replies View Related

ShadowUploader With Other Options

The code for ShadowUploader works great for me when I have it on a page by itself. My problem arises when I try to add other buttons. The “Upload” button still works but the other buttons act like just another “Upload” button. What am I overlooking?

<% Option Explicit
Response.Expires = -1000' Make browser not cache pg.
Response.Buffer = True' Buffer content so Response.Redirect will work.
%>
<!-- #include file="~incl/ShadowUploader.asp" -->
<!--#include file="~incl/~config.asp"-->
<!--#include file="~incl/jpsutility.asp"-->
<!--#include file="~incl/menu.asp"-->
<!--#include file="~incl/misc.asp"-->

...............

View Replies View Related

Number Of Options

I have an ASP variable which is a certain number. I want to create a Select tag in a form, which will be populated up to this number. So, for example, if my number was 7, you would have a list of numbers between 0 and 7 to select.I'm not sure how to do loops, but I had an idea that the code would look something like this:
Code:

<select name="select2" id="select">

<%
for i=0 to i=varNumber
Response.Write ("<option value='"& i &"'>"& i &"</option>")
rsBooking.MoveNext
%>

</select>

but, as you might guess, this doesn't play!

View Replies View Related

Reporting Options

I need suggestions to allow my users the ability to print reports from my ASP application that will be quick and easy setup. I need them to choose an option such as

Print all checks for the current week

and receive an output of 1 page per employee . Currently I have the page so someone can view 1 employee on the screen and manually print. But I am looking for some web based report delivery method that will be quick to implement so the user can preview the batch of reports and then print. Similiar to if you were running a report in access.

View Replies View Related

Color Options

I was asked to incorporate colour options for items sold in my shopping cart such as pens.So if I am selling a pen that comes in 4 or 5 or more colours, then I have to create the number of types of collours for the pen. I am looking at creating a colour dropdowns for individual items , but I am not sure how I can do this in backend.I am using Access database and using ASP programming. This is the link which is an example of what I mentioned http://www.27905398.com/product_inf...9a4aed0a18fb81d .appreciate if anyone familliar with this function

View Replies View Related

Folder Options From Asp

I need to know how to do the following..

Rename a folder

Check to see if folder exists and if it does return an error message.

View Replies View Related

Sort Options

Can u help me generate a javascript to sort the options(list) in an asp listbox control?

View Replies View Related

Reload Options

We are viewing the same page on my server in New York. I submit or send something in to an ASP, and it returns to me an updated page. How do I get it to reload showing changes for you in Florida who is just sitting watching the page not touching anything?

I have a frames page setup. When I send in info, I have this code to show changes for me by an automatic reload. it works for me:

<javascript blah blah blah

parent.frames[2].location = 'dataRecov.asp?view=rs';"

How do I update your page in Florida live?

View Replies View Related

ADO Connection Options

where I can get a full list of ADO options for opening a recordset? I'm currently using adOpenForwardOnly but I want my recordset to be able to move backwards to the start of a recordset and several other functions.

View Replies View Related

Selection Options

i am using frontpage ,ASP, and some javascript. how do you create a START-> ALL PROGRAMS selection option. you place the mouse over the "all programs" and you got all selection related to "all programs"

i want to do the same thing with data from a database. how do i do this?

View Replies View Related

Email Options With CDONTS 1.2

I am trying to help out my friend by creating a invoicing page in ASP for his business, basically consisting of 3 pages :
(no sensitive info will be asked for.. )

1.info submission page -cust enters his info
2.info summary -cust info summarised plus quote calculated
3.invoice page -quote emailed for invoicing.

At present I have made the initial set up and it works fine. However, I am using CDONTS 1.2 to email the gathered cookies with the following code:

View Replies View Related

Shipping Options In My Cart?

I have created a few web site apps that use e-commerce technologies using ASP and XML. These are typical sites, with shipping, tax, blah blah. Usually it's standard shipping and is just related to the weight of the entire order.

Now, I've been asked to add several shipping options (i.e. Overnight, One-Day, Standard). My question...I did some searching around first but without luck...are the sites that offer multiple shipping options tied in with another company such as UPS? Or is it just more data that I can deal with on my own?

View Replies View Related

Split Screen Options

I have 10 athletes i will be testing and displaying their information

so there will be two split screens the bottom screen where the user enters the data and the top screen where the data will be sorted to show the ranking of the athletes Code:

View Replies View Related

Duplicated Drop-Down Options

The default drop-down value is populated by a value already selected using Recordset.

The problem is on the Edit page, the user should have the ability to change the drop-down value, but because the default value is one that has previosuly been selected, it appears twice in the list.

Because I already have an "If, Else" statement to disable some fields, it is causing confusion when I try to enter further If/Else statements to narrow down the drop-down list. Code:

View Replies View Related

Adding Form Options

I want to have a poll on a message board and add options by users clicking a button. The code looks something like this...

<INPUT TYPE=BUTTON VALUE="Add" ONCLICK="Add();">
<INPUT TYPE=BUTTON VALUE="Delete" ONCLICK="Delete();">

function Add()
{
// alter the action and submit the form
document.topicform.action = location.href + "1" ;
document.topicform.submit();
}

function Delete()
{
// alter the action and submit the form
document.topicform.action = "deleteformbutton.asp";
document.topicform.submit();
}

As you can see I'm not really sure how I should go about processing the actual form. Each time the user decides to add another form button I want it to keep the value of the old button. Anyone got any ideas?

View Replies View Related

Selecting Drop Down Options

I am trying to set up a component that will allow events that are date sensitive. From this date to that date. What I am trying to do is use drop down menus for selecting the dates, and I am having a hard time finding out how to build these drop downs so when someone is editing an event, the existing dates are pre-selected in the drop downs. But I need to seperate year, month and day for both and then have it change the value of the correct option to selected.What is the easiest way to do this?

View Replies View Related

Disable Windows Options

I need a script that will disable save, save as copy and select all Windows file and edit menu options.

View Replies View Related

DropDown List Options

I have a drop down list on an asp page. Can I have tooltips for each item so when the user scrolls odwn through the drop down I display a tooltip (as some options are long and I do not want to incrase the width of my drop down).

View Replies View Related

Drop Down Menu Options

Below is an extract from a form that i am writing. I need the user to be able to have a drop down menu of languages. How do I use the 'option value' command in ASP like you can do in HTML; so there is a list of languages for one to be selected. If someone could amend my code to give me a couple of language options so I can get an idea of how it is down.

<tr id="r_Lang">
<td class="ewTableHeader"><span>Language<span class='ewmsg'>&nbsp;*</span></span></td>
<td class="ewTableAltRow"><span id="cb_x_Lang">
<input type="text" name="x_Lang" id="x_Lang" size="30" maxlength="25" value="<%= Server.HTMLEncode(x_Lang&"") %>">
</span></td>
</tr>

View Replies View Related

Image Display/controling Options

I've got a directory site for accommodation providers. I would like them to have the ability to display a couple of images on their details page. I can easily set it up so they upload images to my server and DB and are displayed etc etc... But I would rather have them just provide the links so that the pictures remain on their website etc....

The only issue I have is what happens if it is a bad link. By uploading to my server I can remove the risk of images not appearing, but by using a link, is there a way of 'testing' whether there is an image at the end of the link. Is there a script out there capable of verifying if an image file is where it should be for veiwing? My initial thought was to have a script that tests the image link for a width <> 0. On the page I would use an IF statement to allow displaying of the image if the image existed..... BUT HOW ?

View Replies View Related

Form Post Action Options

I have a form with several submit buttons. Each one is different. For instance, one may require the next action window to be a pop up requesting more data. Another may require it to be normal. And of course I need the request data from the form. I tried not specifying the action on the form and put it on the the submit button via the OnClick but the request data was always behind and isn't current until after the submit.

I guess an easy way to think about it is say you have a tool bar and depending on which button you click it fires a different asp file but the current form data.

View Replies View Related

Multiple Select Options At The Same Page

I m trying to use multiple option menu using redirect function in ASP.

I managed to do a single option but I need to use multiple options can you please advise on how to do this, so both options apear in the same page. for instance, in the code below a user should be able to select uk and also selects between the other options; population, geography from the same page. Code:

View Replies View Related

Changing Internet Options Settings From ASP

i am producing some asp report pages for our company intranet but they dont print out correctly unless i change the internet options settings to "Print background colours or images" is there any way i can change this when people open the webpage?

I wouldnt think that is possible so.... is there any way to get around this using style sheets? I havent really used them yet.

View Replies View Related

ASP Code Passing Options To Command Line?

I need an ASP code that will pass some variables as options to a command line.

Let's say I need to execute a program with some options and I need the user
to select the otions from the web interface.

The command line will look something like this:

Program.exe /usename:username /password:password /options:option1,option2,option3

The the user will access a web page and it will be asked for the username , password and
it will be able to select the options by marking them on the page.

After the selection the command line will be executed with the selected oprions.

If somebody can point me to some example code or any hints to get me started I would
appreciated it.

It is possible to specify also the credentials the "program.exe" should run under?

View Replies View Related

Validate Form With Multiple Payment Options...

I have a form where the user has 2 payment options. Is there a way to add validation to the form to ensure that at least one payment method is selected? This form does not actually process the payment, just sends the information to the recipient.

View Replies View Related

Javascript, ASP & HTML Select Object - Duplicate Options

I have an ASP page that uses VB as the language. It accesses my database via RedBack objects and methods. Here's the snafu I've encountered today -

I have a form defined (in HTML). I populate all of the fields within the form with values from the database (the records will always have data when this form displays). I use a for next to loop through the records (with multivalued fields). Here is a piece of the code:

View Replies View Related

Difference Between Private Function And Public Function?

What's the difference between private and public functions in ASP? When should I use either?

View Replies View Related

Display Drop Down Options Based On The Selected Item From Another Drop Down

The code that I have has 2 drop down boxes dd1 (visible) and dd2 (hidden). Based on the option selected in dd1, dd2 should be visible and populate options. I think I can have OnChange script but how could I return the value and put it in the SQL query (see variable in red in thecode)? Code:

View Replies View Related

How Can I Add Mail Function To That Post Function

I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.

this is the send message code ....

View Replies View Related

Function Inside A Function

Can I define a function inside a function. e.g;

function abc()
function xyz()
....some code.....
End Function
End Function

I googled this but can't find any related topic.

View Replies View Related

Function In The InStr Function

I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:

I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.

View Replies View Related

Asp Function

I am trying to call a function in asp to check to see if a varibale has a value stored in it if there is nothing wite the value NA into it. My code is

<%
Function NullValues(userField)
if userField = "" then userField = "NA"
end function

AccountNo = ""
Name = "sam clowes"
email = ""

AccountNo = (NullValues(AccountNo))
Name = (NullValues(Name))
email = (NullValues(email))

response.Write AccountNo & "<br>"
response.Write Name & "<br>"
response.Write email & "<br>"
%>

When I run this code ALL the variables are blank and nothing is output

View Replies View Related







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