Search results for query: *

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

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...

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

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 =...

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...

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), '...

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...

No default value is set. Ta

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

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

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

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...