|
The original developer, may he suffer a lifetime of minor aches and pains, appears to be preparing for some kind of string-parsing which requires each portion of the date to have two characters. This would be better accomplished by ensuring the format of the incoming date; however, I would say you're more likely to cause harm by taking this out than you are by leaving it in.
If, on the other hand, you want this script to be portable to a server with different internationalization settings (e.g. month/day/year), then nuke this immediately.
|
|
|
|
|
This also has the effect of stripping any time values off of the dates. They are datetime values and the time portion may not be used, but if there is a time portion it is being removed and only the date is used. If for some reason that is the goal, I think it's better done this way:
cast(convert(char(10), @datetime, 101) as datetime)
Keep It Simple Stupid! (KISS)
|
|
|
|
|
Hi, i have error" Data type mismatch in criteria expression" when execute : clsADONET.setConnCommand_Close(sCommand) . Can explain for me what's wrong? here is the code. thanks
public void Update()
{
try
{
string cmd;
string field;
string parameter;
field = "Site,Model”;
parameter = "@Site,@model”;
cmd = "INSERT INTO Run(" + field + ") values (" + parameter + ")";
clsADONET.setConnCommand_Open(sCommand);
sCommand.CommandText = cmd;
sCommand.Parameters.Add("@Site", OleDbType.VarChar, 20);
sCommand.Parameters.Add("@Model", OleDbType.VarChar, 20);
sCommand.Parameters["@Site"].Value = CS.site;
sCommand.Parameters["@Model"].Value = CS.DUTSelected.ToString();
clsADONET.setConnCommand_Close(sCommand);
}
catch(Exception e)
{
MessageBox.Show(e.Message);
return;
}
}
class clsADONET
{
public static OleDbConnection sConnection = new OleDbConnection();
public static OleDbCommand sCommand = new OleDbCommand();
public static OleDbDataAdapter sAdapter = new OleDbDataAdapter();
public static void setConnCommand_Open(OleDbCommand sCommand)
{
setConnection(CommunicationSettings .DatabaseonServer);
sConnection.Open();
sCommand.Connection = sConnection;
}
public static void setConnCommand_Close(OleDbCommand sCommand)
{
try
{
sCommand.ExecuteNonQuery();
sCommand.Parameters.Clear();
sCommand.Connection.Close();
sConnection.Close();
}
catch (Exception e)
{
clsLog.LogEvent("Error", "", "Module:setConnCommand_Close(clsADONET.cs) ", e.Message, CommunicationSettings.EventNo);
}
}
public static void setConnection(string dataBaseLocation)
{
if (sConnection.State == ConnectionState.Open) sConnection.Close();
sConnection.ConnectionString = setConnectionString(dataBaseLocation, "");
}
}
|
|
|
|
|
Could the following be the problem?
sCommand.Parameters["@Site"].Value = CS.site;
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
i don't think so, the type is match.
|
|
|
|
|
Based on your code I'm not sure which sCommand is used at which point. You have a static sCommand, you have defined sCommand somewhere in the class where you have Update-method and you pass sCommand as a parameter for methods in clsADONET. So basically you may be even executing a different command.
The first thing I think you should do is to separate the naming so that class field is for example named _command, parameter is named command and the variable in update method is something else. This would help you when debugging the code.
Also if you want to use a single command all the time (based on the fact that you have a single static field in clsADONET) you could remove the parameters from the methods and use more accurate method calling implementation.
Hope this helps you.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
The following query gives me a concatenation of the name attributes of all sections in an XML column, but I need the values to be delimited. How can I do this?
select ExportAgentID, ExportDef.query('for $nm in /ExportSpecification/Sections/Section/@name return string($nm)') from csExportAgent where ExportAgentID = 30
|
|
|
|
|
Brady Kelly wrote: The following query gives me a concatenation of the name attributes of all sections in an XML column, but I need the values to be delimited.
One way to do this is to use concat function:
...ExportDef.query('for $nm in /ExportSpecification/Sections/Section/@name return concat(string($nm),'', '')')...
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Thanks, I actually just figured that out. It seems to use a single space as a default delimiter, which could present problems in some scenarios. Can you suggest any way of preventing this?
|
|
|
|
|
If you want a simple varchar value out then you could use something like:
...replace(
convert(
varchar(500),
ExportDef.query('for $nm in /ExportSpecification/Sections/Section/@name return concat(string($nm),'', '')'
),
', ',
',')...
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Ah, yes, thanks. Actually the spaces don't matter - the result list is for an IN clause anyway, which tolerates spaces.
|
|
|
|
|
I think it's a very common case to import data from an excel file to sql server 2005 thru a stored procedure. There are many solutions solutions such as OpenDataSource methods, cmd call DTS packages etc.
However i have not succeeded in find a receivable solution when the excel file is on the local machine. These methods work only if the file is at the same volume where the sql server is. But what happens if the excel file is at the local volume? I've read all the previous topic - export to excel - and have searched to a lot of other communities but the result was nothing. Has anyone came up against a similar situation?
Thanks in advance
www.netsemantics.gr
|
|
|
|
|
If you want to import an excel file using tools or utilities provided by SQL Server, then the SQL Server must have access to the file. It doesn't matter where the file is. It can be on a network share etc as long as SQL Server can read it.
If your excel file is located on your local machine and you're not able to provide access to it from the db server, you can use utilities like bcp on your client machine to get the data to the SQL Server.
The need to optimize rises from a bad design.
My articles[ ^]
|
|
|
|
|
Hi All,
Its been 2 weeks i am facing this issue.
I have sql server 2005 with Reporting services on Windows server 2003 64 bit machine.
I have configured the dashboard and its working . Sometime it is showing the generated report
But 9 out of 10 times i am getting error.When i checked the log files
at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles below error is displaying
11/27/08 10:31:22, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3096
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x20154C3C
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0153.mdmp
11/27/08 10:31:29, ACTION, w3wp.exe, Watson Invoke: No
Again in event view for Application application below error is coming
Event Type: Error
Event Source: Windows Search Service
Event Category: Gatherer
Event ID: 3083
Date: 11/27/2008
Time: 10:32:13 AM
User: N/A
Computer: CIGSCMMETRIC01
Description:
The protocol handler Search.Mapi2Handler.1 cannot be loaded. Error description: Class not registered.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Please can anyone help me
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
|
Hi Jerry,
Url is not working
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
It should work now.
The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright
|
|
|
|
|
Thanks Jerry ,
Searching for fix now ...
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
Check My Blog
|
|
|
|
|
hi
i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches.
if u present PDFs or articles it is the best.
who can help me?
bye
Mohammad Khansari
|
|
|
|
|
Is there no search button at the top of your screen? Does google not work where you live?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi
ha ha ha ha
what did u mean?
google is working here!!!!!!!!
bye.
Mohammad Khansari
|
|
|
|
|
m-khansari wrote: what did u mean?
I mean its as easy for you to use the seach function on CP or google as it is for anyone else to do the search and send you the links. Its generally known as doing your own research, unfortunately it does not seem to be widely practiced judging by the majority of posts on these forums.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi prodigy
i have searched by google these words
versioning software
versioning system
versioning .net
versioning control
versioning database
versioning tools
versioning C#
versioning ADO.net
content versioning
versioning implementation
versioning methods
row versioning
record versioning
data versioning
but i reached only 2 articles in this field
one article in code project and another in some thing else
can u tell me what expression i must search to reach more articles?
thanks
Mohammad Khansari
|
|
|
|
|
You said
m-khansari wrote: i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches
So first decide on what you actually mean. Do you want to know about data versioning in general, or in relation to a specific CMS product. If the latter, then check with the vendor. If it the former, what do you actually want to know, what it means or how to do it.
As I say, nobody can really help as you are not clear in your requirements.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi
thanks very much.
I want to know how to improve and enhance data versioning performance
and I want to know it's approachs in general.
God bless
Mohammad Khansari
|
|
|
|
|