No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Re:
Database
Hey I've been coding from a young age, I've just recently turned 18 I want to create an application for me and my friends to use, it scans a folder and from that folder it gains the movie information based on their backed up movies filename, I have a method …
|
|
|
Hi all, I'm not the best with coding and was wondering if some one can help me out. The page is inserting information into a database but when i added an extra section to insert i get the error [CODE] Could not find stored procedure 'Insert_PublicationsA'. Description: An unhandled exception …
|
|
|
Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) …
|
|
|
I cannot figure out the declarations to write to an excel file that is already open. I open the excel file and make it visible with this: Private Sub Button1_Click Dim objExcel As New Excel.Application Dim objWB As Excel.Workbook objWB = objExcel.Workbooks.Open("F:\My Software\files\test.xls") objExcel.Visible=true End Sub What are the declarations …
|
|
|
Re:
sql update query
sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this …
|