Search results for query: *

I want every keystroke of typing a numerical value (weeks) into a text field, to immediately change values in two other fields. Have put the script in the onblur__ Action but to trap every keystroke I put it in the Format Custom Keystroke Action. This doesn't seem to work as I had thought ie...

Have got a field which has a date format (dd mmmm yyyy). The date is auto formatted when the user types in the date e.g.: 1 jun 2003 -------> 01 June 2003 However, if I then access the value of that field i get the unformatted user input rather than the nicely formatted date shown to you on...

How do i get the input typed in a multiline text box to register carraige returns as <br>'s when displaying as html in the resulting 'thread' datalist. Is there a simple encoding/conversion method or do i have to recognise and replace the carraige returns at say the stored procedure level...

I need to render the Body or Form tags of every aspx page loaded with a javascript event. This event will open a popup when the main browser is closed. I can add javacript events to objects using: object.Attributes.Add(&quot;onunLoad&quot;, &quot;Logoff.aspx&quot;) So can i reference the...

How can i work out the duration of a Forms Authenticated User on a website so that a monthly total can be kept in the database.

DB stores input from a text area (nvarchar 3000) with carriage returns in it, is there an easy way to get it to then display this in a datareader with the carriage returns still in place ie. <br> instead cheers, si

Always have this problem whenever a DB query returns Null values for certain columns to my Datareader. I don't know how to check if any of the values returned are Null before setting the control Text property or SelectedIndex to it. With the code below i get the following error message...

Have the following stored procedure, that crops html content out of the Description Column in my Events Table: =========================================================== ALTER PROCEDURE GetEvents ( @ModuleID int ) AS SELECT ItemID, CreatedByUser, WhereWhen, CreatedDate...

Have a 'Description' Column in my SQL7 DB which is currently NVarchar (4000). Need to change the data type to allow more characters. NText seemed to be the way to go, but it causes errors saying that its not a valid selection for Argument 1 of the Stuff function (I thought the stuff function...

How do i get the numerical Day component from a Date variable. ie I have a variable declared, and assigned a value as below: =========================================================== Dim dateofbirth as Date Dim users As New ASPNetPortal.UsersDB() Dim dr_id As SqlDataReader =...

New to Director, but need to create a Director project that will effectivley be a template that references a series of files on starting, to provide the content. These files will be of the following type: Graphic file (eg .bmp) Text Movie Clip (.mpg) This will allow the end user to change the...

Have got a stored procedure that returns all news announcements from a table. The string however contains html references to images eg: <br><img src=http://localhost/WAFPortal/images/itemimages/aust104.jpg><br> Is it possible to remove all content from the string enclosed by < > when...

I need to do a FREETEXT search on several database tables but the Full-Text option is disabled (greyed out) in Enterprise manager at server, database, and table levels. What am i doing wrong, cheers, si

Have written a stored procedure that submits Company info into a Company Table, User info into a User Table, and two inserts into a UserRoles table. What i want to achieve is if either the User or Company INSERTS fail becuase of a duplicate field in Email or CompanyName, then all four inserts...

Similar question to one i posted recently. What is the syntax to refer to the value of a DropDownlist selection from within a call to a javascript function: =========================================================== <td> <a class=&quot;CommandButton&quot; runat=&quot;server&quot...

When i pass the following stored procedure the variable @LetterRange with values: a-e or abcde why do i only receive back company names begining with 'a'? =========================================================== ALTER PROCEDURE GetAlphabeticalCompanies ( @LetterRange VarChar ) AS...

I want to display a size restricted window with no menu bar from a Hyperlink control in a Datalist. The URL needs to also pass the CompanyID. The only way i know to open a mini window is using Javascript, so I am trying to combine the call to the Javascript function with the Databinder of the...

Is there a simple way of returning only five results from the following stored procedure (ie those 5 companies who registered most recently) ========================================================== ALTER PROCEDURE GetNewestCompanies AS SELECT CompanyName, RegDate FROM Company...

Whats the syntax for checking if a datalist is empty? cheers, si

What is the syntax to test if a selection has been made in a listbox? I want to execute a sub when clicking a button, but only if they have selected a value in a listbox, cheers, si