Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
5,114 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 103
Page Size: 10 · 25 · 50

Author filtered by: _Damian S_ [x]
Forum Message 13 May 2013  
Mycroft Holmes wrote:Yeah but that is not b/c the code base is crap, just that the client is an idiot! Fair point, well made...
Answer 13 May 2013   license: CPOL
How about select left(FIELDNAME, 50) as AddressPart1 from TABLENAME
C#SQL-Server.NET.NET4
Forum Message 13 May 2013  
Yes, I have. Most memorable is one where the potential client told me how they had spent 2 years developing an application in-house in a particular language, and they estimated it would take me TWO
Forum Message 13 May 2013  
Roger Wright wrote: clean my desk (I work best in clutter, while he can't stand an out of place paper clip) and he'll give me an immediate 10% raise.
Answer 13 May 2013   license: CPOL
Put your alert box code somewhere else, or check for a postback using code similar to the following:if not page.ispostback then alert code hereelse do something elseendif
ASP.NET
Answer 13 May 2013   license: CPOL
Your query should work... Is there something else stopping it from working? Perhaps a link from IterationNumber to another table?Here's another option for what you are trying to do...DELETE ObjectsLog.*FROM ObjectsLoginner join Objects on Objects.ObjectID =...
SQL-Server
Answer 13 May 2013   license: CPOL
This project is beyond the scope of a "Quick Answers" type question. This section is for people who have actually produced some code themselves and have encountered a specific problem with their code.You can certainly develop websites using ASP.NET and VB.NET. You can send information...
VB
Answer 13 May 2013   license: CPOL
Create a crosstab query on the table, using the Crosstab Query Wizard. Put the date as the row heading and Session as Column heading.
C#
Answer 13 May 2013   license: CPOL
Have a table that records the last successful user login (or every login if you like, then just query the last login as required).Upon logging in, check this table (in addition to their user/password) and if the last login was more than 3 days ago, deny them access.
SQL-Server
Answer 13 May 2013   license: CPOL
You get the wrong result because your query will return the maximum bid for each user and Bid_ID combination. You will need to restructure your query so that you can find the maximum bid for an individual Bid_ID, then link it back to get the user details.
SQL
Answer 12 May 2013   license: CPOL
As I've said previously, you need to format your dates 'yyyy-mm-dd' for the queries.SELECT Enquiry.Enqid AS SLNO,Enquiry.Phone, Enquiry.mobile, Enquiry.custname,Enquiry.email,Enquiry.enqdate,Enquiry.enquirysource,Enquiry.workdescription from Enquirywhereenqdate
C#
Forum Message 12 May 2013  
Very old joke, and terrible formatting... Quad skating his way through the world since the early 80's... Booger Mobile - M
Answer 12 May 2013   license: CPOL
Change your functions/procedures/subs/whatever so that they take in either a Stored Procedure name (better) or an SQL string (not quite as good, but will suffice) as a parameter, and use that as the CommandText item...
ASP.NET
Forum Message 12 May 2013  
I think I like this the best because it happens so rarely!! :laugh: Quad skating his way through the world since the early 80's...
Forum Message 12 May 2013  
Is that you in the reflection? Quad skating his way through the world since the early 80's... Booger Mobile - My bright gr
Re: Business logic by _Damian S_
Forum Message 12 May 2013  
Member 9475889 wrote:Anyone else get this much? Do you persist and argue your point or just give them exactly what they ask for? It's not my place to ch
Answer 9 May 2013   license: CPOL
In Access, dates are denoted with a hash #.Try:select AMT from SomeTable where DateValue(TestDate) between #"+ format(fromdate, "yyyy/mm/dd") + "# and #"+ format(todate, "yyyy/mm/dd") +"#"Also, it's a good idea to format your dates yyyy/mm/dd to avoid regional issues.
C#MS-Access
Answer 9 May 2013   license: CPOL
This SQL should work for you.select x,y,z from view1 inner join table1 on ((view1.x = table1.x) and (table1.y='1234'))
SQLview
Help regarding codition by _Damian S_
Answer 9 May 2013   license: CPOL
How about something simple like this:if ((ds.tables("che").rows(0).item("time") >= "01/01/1900 06:00") and (ds.tables("che").rows(0).item("time")
VBVB.NET
Answer 9 May 2013   license: CPOL
Since your stored procedure simply checks whether the IsActive value is 3, and if it's not, update to 3, you could achieve the same thing with this code:update tbl_OPDappointment set IsActive=3 where Docket_No=@Docket_noand IsActive3
SQL2005SQL-Server
Answer 9 May 2013   license: CPOL
You are attempting to open the same file in a StreamWriter multiple times (once for each record). Move the opening of the StreamWriter to before the lineFor Each currentField In currentRowAs an aside, don't forget to close your StreamWriter at some point.
VBVB.NET
Spammer in Quick Answers by _Damian S_
Forum Message 9 May 2013  
http://www.codeproject.com/Members/vula-ali[^]
Forum Message 9 May 2013  
AspDotNetDev wrote: youre err... your? :laugh: :laugh: edit: Strikeout on the e didn't convey the meaning sufficiently... :doh:
Forum Message 9 May 2013  
jschell wrote:And where the father and a couple of neighbors could take the idiot into the backyard and beat him senseless without interference from oth
Answer 8 May 2013   license: CPOL
The third parameter is the title. If you want yes/no/cancel and a question mark, you need to use the + sign between them like this:Dim answer As String = MsgBox("Are you sure ???", MsgBoxStyle.YesNoCancel+MessageBoxOptions.RtlReading, "TITLE HERE")
WindowsWPFVBVB.NET
Forum Message 8 May 2013  
Shhhhhhhhhh!! :laugh: :laugh: Quad skating his way through the world since the early 80's... Booger Mobile - My bright
Forum Message 8 May 2013  
_Maxxx_ wrote:I don't think you really know until you are in that situation. Exactly. Which is how I know I would take action. 'nuff said.
Answer 8 May 2013   license: CPOL
cast (FIELDNAME as int)
SQL-Server
Answer 8 May 2013   license: CPOL
You can't show a messagebox in an asp.net page without using some kind of code...Try this:System.Web.HttpContext.Current.Response.Write("alert("You have been alerted")")
ASP.NET
Forum Message 8 May 2013  
I really liked this one that was in the suggested videos to the right: clickety[
Forum Message 8 May 2013  
As if CG's internet would remain up long enough for even 45 screenshots to download!! Quad skating his way through the world since the early 80's...
Forum Message 8 May 2013  
I never beat your wife either!! :laugh: :laugh: Quad skating his way through the world since the early 80's... Booger M
Forum Message 8 May 2013  
_Maxxx_ wrote:I seriously wonder what I would have done in the same situation? (hearing the screams, not beating his wife) I don't have to
Difficult SQL JOIN LEFT by _Damian S_
Answer 8 May 2013   license: CPOL
SELECT USERS.Name, USERS.Surname, COMMENTS.Id_COMMENT, COMMENTS.text, ORDERS.name FROM USERS LEFT JOIN COMMENTS ON COMMENTS.Id_USER = USERS.Id_USER LEFT JOIN ORDERS ON ORDERS.Id_USER = USERS.Id_USERYou only have one User ID listed in the Order table, so you only need one link to the...
SQL
Forum Message 8 May 2013  
55 seconds in... clickety[^]
Forum Message 8 May 2013  
mark merrens wrote:You need professional help - I think your BIL under-reacted. And this is precisely what's wrong with society these days..
Forum Message 8 May 2013  
Eddy Vluggen wrote:You're free to prefer the woes :) Best response ever!! :laugh: :laugh: Quad skating hi
Answer 7 May 2013   license: CPOL
When you are saving your dates to an Access Database, to ensure they are saved in the correct way (it changes depending on regional settings), you should format them #yyyy/mm/dd#This will resolve your issue.
C#MSAccess
Answer 7 May 2013   license: CPOL
We migrated from SQL 2005 to SQL 2012 recently, and found that there weren't too many issues. Assuming you have set your code up to pass through information to your SQL Server correctly, using standard methods, it should work.One issue I did come across related to Triggers, particularly...
C#WinForm
Answer 7 May 2013   license: CPOL
Open Visual Studio.Select File-->New Project.Enter Details.Create Project.Compile.Deploy.
C++
Forum Message 7 May 2013  
Keith Barrow wrote:respected for his input That leaves out CG!! :laugh: :laugh: Quad skating his way throu
Forum Message 6 May 2013  
OriginalGriff wrote:"Does my bum look big in this?" Yes, but at least it takes the focus off your face!! Qua
Re: Leaving a company by _Damian S_
Forum Message 6 May 2013  
Work your standard hours and put in a reasonable effort to make progress. Remember to save some time in the last two days (if you can stretch it out that long) to do a thorough handover to someone el
Answer 6 May 2013   license: CPOL
Your browser is working as designed.
C#ASP.NET
Answer 5 May 2013   license: CPOL
Looks pretty close... This is how I do it (VS2010).Dim crDoc As CrystalDecisions.CrystalReports.Engine.ReportClassDim pvParamValue As New CrystalDecisions.Shared.ParameterValuesDim pdvParamDiscreteValue As New CrystalDecisions.Shared.ParameterDiscreteValuecrDoc = new...
VBAccessVB.NETCrystalReports
Answer 5 May 2013   license: CPOL
update TABLENAMEset c3 = c1where c1 1Edit:Scratch that... I answered your actual question rather than what you showed in your sample data.
SQLServer2008
Answer 5 May 2013   license: CPOL
You don't have the OLEDB provider installed on your IIS server. You could install the Microsoft Access Jet redistributable package to achieve this.
ASMMS-Access
Answer 5 May 2013   license: CPOL
Your query is just about correct as it stands... just one thing isn't quite right.The "having" clause is only required when you are wanting to perform some operation over set functions, eg: sum(X), min(Y), count(Z) etc... this is not required in this case. A simple where clause will suffice...
GimmeCodeHomework
Answer 5 May 2013   license: CPOL
Your issue is that when inserting the More Info part, you aren't specifying the foreign key to link the record back to where it belongs. Specifically, you need to include A_ID and ID (and specify values for them) when inserting into MoreDetails.As an aside, you are also missing the @ symbol...
C#ASP.NET
Print Crystal Report by _Damian S_
Answer 5 May 2013   license: CPOL
By definition, whatever is showing on the report will be printed.If you only want the main report, copy your existing report and remove the sub-reports (from the copy)... call it something like "REPORTNAME-MainReportOnly" and provide a link to print that in your program.
CrystalReports
Page 1 of 103
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid