Search results for query: *

I am in a position that I've never been in before...needing to give a time frame on a project. The project is a new application to replace an existing 3rd party application we use (Tenrox). Its a project time tracking software, where they will need the functionality of entering the time...

Sorry if this is wrong forum to post this... Easiest way to explain this is: I am trying to replicate an HTML table design of 2 columns with 50% widths. Meaning that as the page size is increased, both columns grow equally. I'm trying to do this on a windows form...with two group boxes. As...

I am new to XML and trying to do a simple read, currently i'm attempting to use XmlTextReader, but if you have a another suggestion that works I am not picky =) Here is what I have, which doesn't work: Dim sr As StringReader = New StringReader(Me.hidSpellXML.Value) Dim...

I created a small .exe that runs nightly and exports a crystal report as .pdf files. Untill recently (2 weeks) ago, it ran fine for many months (11+), now it is erroring occasionly on the Report.Export() call. Source: CrystalDecisions.CrystalReports.Engine Message: Logon Failed. I've done a...

I need to change up an existing query in an application, I have no CF expierence so need the details, as I have no clue on debugging or anything like that. Existing query: <cfquery name="qry_select_client_contact" datasource="#request.dsn#" dbtype="#request.dbtype#"> select...

I am creating a usercontrol and would like the stylesheet applied in design view in VS2005 so I can see what the heck I am creating. Currently the only way I can see how the control is going to look is to run a page the control is used in, which is very annoying. Since the usercontrol has no...

While running a script I created that will be transferring data from our existing database (SQL 2000) and converting the data to our new system in SQL 2005 and inserting it. The script got about 1/4 of the way through, and then errored with: Msg 1105, Level 17, State 2, Procedure...

Which design would I be better to go with? Table A ID ID2 Col1 ... Col50 Col1 thru Col50, not every column will have data, and there will be at least 20k rows to start, growing by about 40 a day. The most used query would return 1 row which would be found by ID = ID or Table B ID ID2...

There is one stored procedure that is giving me tons of grief. When I run it in Query Analyzer, it takes 6-10 secs to run. But when called through an application, it is taking 5+ mins. For whatever reason, it is not being run directly when called through coldfusion, but through sp_prepexec...

we have a SQL stored procedure that is causing an issue when called through coldfusion, it is taking an extremely long time to run....5+ minutes sometimes The issue is, when run through Query analyzer it runs in 2 secs. I have no other ideas of how to increase the speed of the queries in the...

I am trying to create a dataset relation between 2 columns in the parent, and 2 in the child but not having any luck id1 is unique id2 is not What I need is id1 and id2 combined to make a unique relation. I don't know how else to describe it so I'll try to draw out what I want id1 will be...

I have a standard exe with one form which is set to visble. When I first ran the exe the form was not visible. I added the code in form load to set it to visible again, and show(), ran the exe again...this time the form showed briefly, then disapeared again. It continues to run as I can see...

I have the following code which works fine in IE6 <table width="12" cellpadding="0" cellspacing="0" onclick="menu_click()" class="trans"> <tr> <td background="images/clientSliderFull.gif" height="150"></td>...

I am trying to return some data from a MySQL database, I am having trouble reading one of the columns though... The columns datatype is set as Time. When I read it through the datareader, it is of TimeSpan type. If I do a myDR("time").tostring it gives me 00:00:00 for every row. My...

I would like to create a trigger on a table to either log in a serperate table, or send an email of the rows that were just deleted from the table. Is this possible? Can someone hold my hand and walk me through? ;) Thanks

I don't know if I'm even going about this the proper way, but I am creating a .dll to include in my projects that is just a class that handles a certain area of the business that every application will use in the future. I figure if something needs changed with this area of business, if built...

I need to output a ntext data column in a stored procedure, but i'm getting an error: Error 409: The assignment operator operation cannot take a ntext data type as an argument. The decleration is as follows: @Comments as ntext OUTPUT The assignment is: @Comments = Comments How can I...

I have a report that requires that the user select a start date and an end date for the range of the data. Using the crystal report viewer, they select the 2 dates... The first date has the correct time of 0,0,0 being 12:00:00AM I would like to make the second date they choose move to...

Is the time it takes query anylzyer to execute a SP comparable to the time the same SP would be called from an outside application? My problem is I have an app that calls 4 SPs to load up a report, this report time outs 95% of the time at end of month as more data is entered. (Time outs...

I believe its EXEC SP_Name correct me if i'm wrong But how do you execute a SP in query analyzer that has parameters? Both Input and Output?