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!

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

    check file size

    Hi I wonder if there is a way to check a file size before the file is uploaded to the server. Regards
  2. magmo

    sloooow dvd burner

    Hi I have a P4 3.6ghz with 3 GB RAM and a Sony DVD RW DW-Q30A. I use Nero to burn with. When I burn a DVD, it says that it burn in 8x, but a file that is 4 GB take me 1 hour to burn, that is obviously not correct. There must be something wrong. Beacuse when I do the same thing on a P4 1.5 Ghz...
  3. magmo

    pass string value to type decimal

    Hi I have a form that holds a textfield, this textfield get its value from a sql server database, and the datatype for that specifik column is ... Decimal Precision: 18 Scale: 2 When I then try to update that value with the textfiled from the form, a value can for example look like this...
  4. magmo

    create xml file from sql server

    Hi I have a database that looks like this.... NodeID ParentNodeID Text NavigateUrl 1 books # 2 1 book 1 page.aspx 3 1 book 2 page.aspx 4 3 pockets page.aspx 5...
  5. magmo

    subquery error

    Hi I try to run the following query.. SELECT (SELECT DISTINCT Artno, L, D, CreatedBy FROM dbo.tbl_Art WHERE (L = N'SE')) AS SE, (SELECT DISTINCT Artno, L, D, CreatedBy FROM dbo.tbl_Art WHERE (L = N'GB')) AS GB FROM dbo.tbl_Art But I get a error message telling me..."only one expression...
  6. magmo

    loop folder and check for a file

    Hi Is there anyone that could show an function that loop through all files inside a folder and check if a file exsits. Regards
  7. magmo

    check if file exsists

    Hi I would like to create a function that check inside a folder if a file exsits, and if so return True. Could anyone help me out here in vb.net Regards
  8. magmo

    loop through checkboxes in a form collection

    Hi I have a form that has x number of values in itself. It is filled with data from a database, each row from the database make a new position in the form. And each position has a checkbox to it. The checkboxes has a javascript assigned to it, so if all checkboxes that has the same name is...
  9. magmo

    1 row insted of 2....

    Hi I have this sql question... SELECT DISTINCT FileName, Lang, Artno FROM dbo.tbl_ArticleFiles WHERE (Artno = N'123456') AND (Lang = N'SE') OR (Lang = N'GB') This give me 2 rows that looks like this... FileName Lang Artno file1_se.txt SE 123456...
  10. magmo

    conditions in stored procedure

    Hi Is it possible to check if a value in a stored procedure is "" and if so not make an update. UPDATE tbl_database SET txt1 = @txt1, txt2 = @txt2, WHERE (ID = @ID) Lets say for example that @txt1 is "" then I don't want to make any update for txt1...
  11. magmo

    find a value that doesn't exsists in table2 but in table1

    Hi I have 2 database tables with a common column, I would like to find all records that exsists in table2 but not in table 1. I guess this is a easy task, but I'm lost right now..... Regards
  12. magmo

    file over 4 mb causes buffer error

    Hi I have a page that generate a pdf and send it to the web browser through Response.BinaryWrite. The asp page runs on a Windows 2003 IIS 6 server, and since this file tend to be larger that 4 MB I get an error from the server. I realize that I have to change settings in the machine.config...
  13. magmo

    cant retrieve dropdownlist value....

    Hi I have added a drop downlist on the aspx page and filled it with items. It looks like this.... And in the codebehind I have this code... <asp:dropdownlist id="ddl" runat="server" Width="144px" AutoPostBack="true" SelectedIndexChanged="Selection_Change"> <asp:ListItem...
  14. magmo

    try catch error...

    Hi I try this code in VS.. Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick If Not File1.PostedFile Is Nothing And File1.PostedFile.ContentLength > 0 Then Dim fn As String =...
  15. magmo

    check date if weekday or holiday.

    Hi I wonder if it possible to check if a date is a weekday or a holiday in vb.net. Regards
  16. magmo

    check all if one checkbox is checked

    Hi I wonder if there is a way to automatically check a group of checkboxes if the client check one of them? Regards
  17. magmo

    structure result in sql query

    Hi I have a database table that contains theese columns... Name Language Trans Description Book 1 US Y US Book Book 1 GB Y GB Book Book 1 ES Y ES Book Book 2 US Y US Book Book 2 GB Y GB Book Book 2 ES Y...
  18. magmo

    disable new line in datagrid

    Hi I wonder if there is a way to disable the last (new) line in a datagrid. Regards
  19. magmo

    ExecuteNonQuery() error

    Hi I try to use this code in a vb.net application but I get a an error on the "MyCommand.ExecuteNonQuery()" line. I dont see any faults in this code, am I missing something here? Dim MyConnection As SqlConnection Dim MyCommand As SqlCommand Dim MyDataReader As SqlDataReader MyConnection = New...
  20. magmo

    Replace null values in db atble

    Hi Is there a way to replace null values in different columns in a database table with ''? I know I can run a update on the table, updating each column. But I would like to it in one action Regards

Part and Inventory Search

Back
Top