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: qwert231
  • Content: Threads
  • Order by date
  1. qwert231

    Getting only Month from db into drop down

    I want to get a list of months from my database. I want my drop down list to show only months that have orders. I have SQL query to get the number of the month, but how can I convert it to text? Mark Kenyon II http://www.geocities.com/qwert231
  2. qwert231

    Mass changes from a datalist.

    I have my datalist with one check box, and one text box. Is there a way to just have a data adapter update set all the changes at the database? Or do I have to read through each datalist item and update one at a time?
  3. qwert231

    Using DropDownList in Datalist for multiple items.

    I have a datalist that will show a dropdownlist for every item. I want that datalist to reflect a value stored in the database as well as allowing the user to change that value with one of the other items in the list. Any pointers?
  4. qwert231

    Set decimal places in typed dataset?

    I have a typed dataset that gets filled from a SQL table with money datatype fields. When I bind to my text boxes I get 4 decimal places. What's the best way to show only 2 decimal places? Thanks.
  5. qwert231

    Can textboxes have onUnFocus events?

    I want a VB.Net event to fire when the cursor moves out of the text box. Can I do this? If so, how?
  6. qwert231

    When I add the WHERE clause mGroup

    When I add the WHERE clause mGroup = @Group my query breaks, but when I drop that part (the part in red) it works. Any ideas why? The mGroup field is a nvarchar(50) field. DECLARE @Job int, @Group nvarchar(50) INSERT INTO #TempTable ( ImageName ) SELECT ImageName FROM Photos WHERE...
  7. qwert231

    I wanna get @@Identity from a stored procedure.

    Here is what I have: CREATE PROCEDURE dbo.MakeSession @month int, @job int, @MDate smalldatetime, @SesID int OUTPUT AS INSERT INTO Sessions (EvntMonth, JobNumber, SessionDate) VALUES (@month, @job, @MDate) SELECT @SesID = @@IDENTITY I want to get SesID from an ExecuteScalar call from...
  8. qwert231

    Where can I store values for a WinService?

    I am developing a Windows Service that monitors a directory, but I would like a few parameters stored, such as the folder to monitor, a destination folder, and some other options. I don't want to have a database for it, I think that is overkill, and these are set once parameters. Should I do an...
  9. qwert231

    DB file is in use message

    I have a database file (Access) that I use for my web site. It used to be that I could be in the database while users viewed web pages, even if those interacted with the database. That no longer happens. It seems that now when somebody access the database, it is locked to all other users. Any...
  10. qwert231

    How to remote debug?

    My page works fine on my test system. Upload the code to the production software and try it, it works, but it seems to not fire certain functions. But there are no errors. So I want to debug the code at specific points, as if it were local. How can I set this up? I have VStudio 2003 Pro.
  11. qwert231

    T665C for sale, works, bad screen

    Looking for a cheap screen, or a buyer for this Clie.
  12. qwert231

    I want to get Mac 8.1 on the Net

    This Mac has a ethernet connection, and I can get out on the network. But I can't get on the internet. I am a PC person so I would like some help figuring out where to put settings. What does the Router address really want to know, would that apply to the gateway? Or would Search domains apply...
  13. qwert231

    SQL string works in access but not from VB.Net code

    My page is in VB.Net, and tries to do an OleDB.ExecuteNonQuery on this string: INSERT INTO tblGCardDetails (OrderID, Image) VALUES(5924045, '0007') I get an System.Data.OleDb.OleDbException: Syntax error in my code. The same string works when dropped into an Access query. What could I be missing?
  14. qwert231

    DataList with Radio buttons?

    I have my datalist, and I have a radio button inthe Item Template. But when I load the page, the radio buttons are not in a group, so I can select more than one. I don't want that, I want to only select one item from the datalist. Any ideas? I figure it's something simple that I'm missing. Thanks.
  15. qwert231

    Unbound field w/ 2 values is blank when 1 is null.

    I have an unbound field with 2 fields combined with a , in between. But if the firstname field is blank, I get nothing in the field, even though the lastname contains a value. Here is my field's formula: {viewSubjInfUC.LastName} & ", " & {viewSubjInfUC.FirstName} I want the field to...
  16. qwert231

    Best Practice?

    K, I have a table where records are associated with groups. Like this: RecID Desc Path Group 1 FirstItem c:\path FirstGroup 2 SecondItem c:\newPath FirstGroup 3 AnotherItem c:\path SecondGroup 4 SomeThing c:\path2 ThirdGroup I am going to...
  17. qwert231

    Watching for events in Form2 while Form1 does something.

    I think this might involve Threads, but I'm not sure. I have a form, it's going to do some work, and update a dialog box with a progress bar. This dialog box is going to have a cancel button that would end the procedure in the form. How can I go about doing this?
  18. qwert231

    I want a query that gets data from 2nd DB

    K, here's the deal. On my SQL database I have 2 tables. I want to get data something like this: SQL db Stored Procedure (since I can't do a view with a query.) SELECT sqltable1.Field1, sqltable1.Field2, sqltable1.Field3 FROM sqltable1 INNER JOIN sqltable2 ON sqltable1.Field1 = sqltable2.Field1...
  19. qwert231

    Unable to open module that doesn't exist.

    I get this message: Unable to open module file 'C:\...\Copy of crUnderCrossHome.vb': The system cannot find the file specified. That file does not exist. How can I get rid of this message? Thanks.
  20. qwert231

    Can I email a Print Document.

    I have code that creates a Print Document. Is there an easy way to convert that to text, or to e-mail the generated document? I know it's a graphics file, but most of it is text. Probably not an easy way, but any ideas would be useful.

Part and Inventory Search

Back
Top