HERE IS THE FUNCTION:
ALTER FUNCTION dbo.FN_GET_QUARTER
-- the parameters for the function here
(
@FN_Qtr_date datetime
)
RETURNS INT
AS
BEGIN
RETURN datepart(qq,@FN_Qtr_date)
END
HERE IS THE SQL REPORT:
IF(SELECT(OBJECT_ID('TEMPDB..#T1'))) IS NOT NULL DROP TABLE #T1
SELECT L_NUMBER, LAST_MAINTENANCE_DATE,
...
Ok here is part of the code that is causing the error:
char charlieReturn[10000];
charlieReturn[10000] = system("osascript /applications/jarvis/scripts/getTextCharlieResponce.scpt");
self.charlieOutput.stringValue = charlieReturn;
The getTextCharlieResponce.scpt returns something like this: "Hi my name is charlie" and maybe som...
hi,
i'm developping a little app under vb6 which grabs html from a site via xmlhttp.
the problem is - i'm getting this error: "This page has an unspecified potential security risk - do you wish to continue?"
seems like it's coming either from the OS directly or from Internet Explorer.
i've already tried changing the internet-options u...
Trying to get a handle on the FTP library in Python. :)
Got this so far.
from ftplib import FTP
server = '127.0.0.1'
port = '57422'
print 'FTP Client (' + server + ') port: ' + port
try:
ftp = FTP()
ftp.connect(server, port, 3)
print 'Connected! Welcome msg is \"' + ftp.getwelcome() + '\"'
ftp.cwd('\\')
x = '1'...
I am tearing my hair out over this error.
------ Build started: Project: shotfactorybatchgen, Configuration: Debug Win32 ------
shotfactorybatchgen.cpp
c:\documents and settings\administrator\my documents\visual studio 2010\projects\shotfactorybatchgen\shotfactorybatchgen\Form1.h(307): error C2664: 'fprintf' : cannot convert paramete...
Hi, I want to know what this form1.resx button is all about. I read up this thread and got to know more about the Program.cs(main() file), form1.cs(logical code) and form1.Designer.cs(UI related code) but not the form1.resx file. Is there any harm if I delete it. What is the purpose of the form1.resx file ??
Many Thanks
...
Possible Duplicate:
How to show a error message if the data is already inserted in the database in c#
protected void Button2_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection("Data Source=KING;Initial Catalog=semasinter;Integrated Security=True");
SqlCommand command = new ...
I'm facing a recurrent problem that I don't know why it is happening. It happens all of a sudden. I didn't do anything different from what I was doing before.
I'm using these tabs: http://developer.android.com/resources/tutorials/views/hello-tabwidget.html
When I open one of the three tabs (Class name = Tab1), this problem comes out. B...
I have recently started experimenting with LLVM under MinGW. I have read the Kaleidoscope tutorial but now I'm having problems with external functions.
I'm declaring external functions like this:
const Type* doubleType = Type::getPrimitiveType(ctx, Type::DoubleTyID);
std::vector<const Type*> doubleParams;
doubleParams.push_back(doubleT...
I have an input db2 table with two elements: loan_number, debt_to_income; this table's name is #Input_Table. I am trying to run a test the function by running a SQL program against this table. The problem is that the function's element is not being recognized in the SQL program for some reason, maybe I have been looking at to long? I nee...
So I am running python 2.6 on a macbook pro and trying to write the code in python to display an image from a file in a label on a tkinter gui. The image is called image.png. The program runs without errors when I use this code
i = Image.open("image.png")
but when I do this code (I add one line):
i = Image.open("image.png")
photo = ...
Hi All
I just purchased a website template from DreamTemplate.com, and have tried to send a test e-mail from it online and instead of sending the e-mail it just comes up with red text saying: "ERROR!".
I am not very familiar with PHP, but I can understand the syntax. The code is below:
Contact.html
<script type="text/javascript">
// ...
Hello everyone!
I'm currently building an iphone app based on gsoap for the communication. I'm trying to manage connection problems and I can't find any specific return statement when the device is not connected to host.
Is there a way to get some kind of exceptions when running gsoap send or reicv methods?
Thanks for help,
Romain
...
Hello all,
I am currently studying for the SCJP certification using the Sierra and Bates Study Guide and in many of the self tests (mock exam questions) I keep running into the same problem - I can't tell whether a particular error will be at runtime (an exception) or at compile (compile error). I know this is a bit of a vague question ...
Error 12 Declined returned in PayFlow.
What can be the reason?
...
I'm trying to lint the source files from a VS 2008 project of mine, but although headers files are processed correctly, cpp files are not.
Lint process is stopped and this error is shown:
#error _WIN32_WINNT settings conflicts with _WIN32_IE setting
C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include\sdkddkver.h(217) : Error
309:...
I'm trying compile LuaJava and I'm getting this error:
Microsoft (R) Program Maintenance Utility Version 9.00.30729.01
Copyright (C) Microsoft Corporation. All rights reserved.
"C:\Program Files\Java\jdk1.6.0_20\bin\javadoc" -classpath "src/java/" -
public -d "doc\us\API" src/java/org/keplerproject/luajava/JavaFunction.java s...
I have a project in which I'm accessing a MySql database on my web server via MySql ODBC driver 3.51. So far I've stuck to writing the ASP.NET C# code for this web app in notepad and just using runtime compiles on the server side to operate everything. So instead of using something like:
<%@ Page Title="Add Order" Language="C#" MasterPa...
It seems like it´s not getting the right method or siganture. It has already worked for a long time, but yeterday I got this Error and I don´t know where I can start.
I reinstalled the plugin "export 0.3" and I installed the newest Verion "export 0.6". All attempts were in vain. I´m using Grails 1.2, Groovy 1.7 and export 0.6. Here...
I use lazy loading in my application. When I work on my source code and view it in my browser there isn't any problem but when I publish my web application, this error shown :
The following types may not be used as proxies:
Faraconesh.BusinessFramework.Common.OrganizationalMonth: field bkpStartDate should not be public nor internal
Fara...