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 derfloh 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: *

  1. nimishauk

    Deploying asp.net web service

    Hi I have created a asp.net web service in visual studio 2005. I have then gone and used the wsdl.exe to create the service in vb? No i need to deploy this on a server so that other web service can call mine. What do i need to do next.... help N
  2. nimishauk

    Grid pane in the table in enterprise manager

    HI When you right click open table to return all rows, click on the "Show/Hide Grid pane" icon . When you click on any row the first column called "Column" a dropdown shows all the filed names of that particular table. This feature used to work fine untill recently wherein...
  3. nimishauk

    Query to be run aginst both SQL and Oracle db

    Hi Jedi I've sorted it . It can be done just need to do a union. Ta for the reply. N
  4. nimishauk

    Query to be run aginst both SQL and Oracle db

    Hi I've been made aware that in Oracle 8 db, outer and inner joins donot work. How can use the foll query to work against both dbs. SELECT AppUser.Forename, AppUser.Surname, AppUser.ID FROM Training_Course_AppUser LEFT OUTER JOIN AppUser_TrainingCourse ON Training_Course_AppUser.AppUser_ID =...
  5. nimishauk

    New line character

    HI I have a query which populates a field by concatenating few other fields. For each field concatenated, the value should be displyed in a new line. An exmaple SELECT 'INSERT INTO Table1( Title) values (''Name: ' + ForeName + ' Surname: ' + SurName + ' Title: ' + Title +);' FROM Table2...
  6. nimishauk

    Display date as an empty string rather than 01/01/1900

    HI SonOfEmidec1100 I guess what your are saying is what I'm looking for but how to I incorporate into my statement below. Thanks again guys, really appreciate the input. SELECT 'INSERT INTO User(Surname, DOB) values ( ''' + Name + ''', ''' + REPLACE(CONVERT(CHAR(11), Date_Of_Birth, 106), '...
  7. nimishauk

    Concatenating fields

    Hi I'm migrating an access db to SQL and have to concatenate few fields to fit into one field.When I create these insert statements, I need the values to be stored in the database with space between the concatenated fields hence when it gets displayed it show as new line for each field. i.e...
  8. nimishauk

    Display date as an empty string rather than 01/01/1900

    No default value is set. Ta
  9. nimishauk

    Display date as an empty string rather than 01/01/1900

    Hi In the database if a date field is set to null, the vlue returned is still 01/01/1900. I would like to be displayed as an empty string. The field is set to allow nulls and there is not trigger which sets the date. Very frustrating. Hoping to hera some good news. Regards Nimisha
  10. nimishauk

    Type mismatch error

    I've been kicking myself. I was not calling the right variable hence the error. Ta guys, appreciate the help
  11. nimishauk

    Type mismatch error

    HI When an user edits a text box on the page which has a default value displayed as 0, and enters no value, get a type mismatch error. Even though I try to set the value back to 0 no luck Code nTotalTime = (nActualHours * 60) + nActualMins nActualMins = nTotalTime mod 60 Ani deas? Nimisha
  12. nimishauk

    Insert statement

    Hi Below is my insert statement INSERT INTO AppUser(Forename, Surname, Job_Title, DOB, Employee_Number, User_Type,Employee_Site_ID) values ('J', 'N', 'GMANAGER', '1955-07-20', '01', 'E', '2 '); When the row gets inserted into the table the DOB is saved as '1955/07/20' rather...

Part and Inventory Search

Back
Top