Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Cenedra
  • Order by date
  1. Cenedra

    need help retrieving textbox values in nested data grids

    I have a DataList with nested DataGrids in the item templates. The datagrids have text boxes where a user will enter a quantity of an item. I can compute these totals if I have one data grid, and I can reference it. So I have the code to find the control of type txtbox names such-and such...
  2. Cenedra

    Need help retrieving values input into a TemplateColumn TexBox

    Basically what I have is a datadrid I'm filling with accessories for a product that can be ordered. In a TemplateColumn, I've added a asp:TextBox. This is the box a user would enter the Quantity of the accessory they want to order (if they want). How do I loop through each DataRow in the...
  3. Cenedra

    Need help with a user defined function

    How do you return a scalar value derived from a select statment within a user defined function?
  4. Cenedra

    Need help selecting from a row in a table and inserting a new row

    Hi everyone, Want I need to do is basically copy a row in my table and insert it into the same table, giving it a different ID. here is my SQL statement insert into events (Title, [Description], Location, CreationDate, LastSavedDate, StartDate, FinishDate, TimeId, LabelID, IsAllDay, UserID...
  5. Cenedra

    Help Using LIKE with a Variable

    here is my stored proc: CREATE PROCEDURE sp_SearchByEmail ( @Email varchar(100)= null ) AS SELECT username, users.id as UserID, displayname from UserProfiles join users on users.id = userprofiles.id where email like '%@Email%' GO The liek part isn't working like I want it to.... if...
  6. Cenedra

    How do I capture the event of the web browser is closed?

    I want to do some processing on my site if they close out of the browser; how can I capture this? Thanks for your help in advance
  7. Cenedra

    Need help displaying data

    I did use the "obvious" table and divs inside and it was still not wrapping.
  8. Cenedra

    Need help displaying data

    I've never output my content in a div before, do you have a sample I can look at? Thanks very much for your help!
  9. Cenedra

    Need help displaying data

    What if I don't want scroll bars and just want all the data output? Do I not set a height for the div and that will work?
  10. Cenedra

    Need help displaying data

    Here is my scenario. I have a users that have profile, and they fill out a series of questions about themselves. All the questions aren't required. When I just display them, I only want to display the items the user has filled out. I have this logic down. However, when I display my data...
  11. Cenedra

    Having trouble getting a Session variable's value

    I'm assigning the value when a person logs in. This page is accessed after a person logs in and the variable is set. I use the above syntax to access the value of the Session variable in other places and it works just fine.
  12. Cenedra

    Having trouble getting a Session variable's value

    Hi everyone, I have an .aspx file that is used by an external program to perform a function. There is no code behind, all code and HTML is contained in one file. the structure is like this: <% string strBlah = Request.Querystring("jdkfsd"); string userid =...
  13. Cenedra

    Need help with Stored Procedure Syntax

    @FriendID should really be @FriendUserName in the variable declaration section, btw.
  14. Cenedra

    Need help with Stored Procedure Syntax

    I've got this stored procedure, and I know it is wrong, but am not sure how to make it right. CREATE PROCEDURE [dbo].[sp_CreateNewConnection] ( @UserID int = NULL, @FriendID varchar = NULL ) AS INSERT INTO CONNECTIONS (userid, friendid)...
  15. Cenedra

    Database list empty - but the databases are there

    Hi everyone, I was working on a remote SQL Server in Enterprise Manager and my internet connection died. So I closed EM and Query Analzyer and rebooted my computer after the internet connection was fixed. Now, when I expand the Registration for the remote server, and I expand the list of...
  16. Cenedra

    Converting data in one field from integer to decimal

    Well I really think I need some coffee. This worked: update clients set maoverage=(maoverage / 100)
  17. Cenedra

    Converting data in one field from integer to decimal

    Well.... duh on my part there. Having all sorts of problems and not thinking clearly there :) Can I do that in a query? Or do I need to write a program to do it?
  18. Cenedra

    Converting data in one field from integer to decimal

    Hi all, I converted some legacy data into a SQL Server database. When I inserted data, I thought I was getting whole numbers. Unfortunately, that wasn't the case, so I inserted whole numbers into this particular field. For example, in the legacy data, I had the value 200, and it is now in my...
  19. Cenedra

    Need help on query syntax

    I'm updating a field across two databases. I know I"m close, but can you please tell me where my syntax is wrong here? update Q_UCDavis_1009.dbo.Clients set Q_UCDavis_1009.dbo.Clients.Race = Q_UCDavis_RACES.dbo.Clients.Race where Q_UCDavis_1009.dbo.Clients.SSN =...
  20. Cenedra

    Help importing from Excel

    I've been asked to import an Excel file into a Microsoft Access database. Some of the fields in the Excel file are formatted as numbers. Without changing any formats in the Excel file, how would I import all the data as text fields into Access? Thanks for your help! Cen

Part and Inventory Search

Back
Top