abehm
Last Activity: Jul 20 '09, 05:52 PM
Joined: May 4 '07
Location:
-
The command contains illegal characters or keywords (It does?)
INSERT INTO DCDTA812.F57480 1Z (CDA301, CDDOCO, CDDCTO, CDTYPS, CDLITM, CDLOTN, CDAN8, CDSAID, CDMMCU, CDDL01, CDISSUE, CDWHO2, CDPHN1, CDSRST, CDCL01, CDPBTM, CDANO, CDPARS, CDSERP, CDCL02, CDPTME, CDANP, CDITM, CDNUMB, CDEDSP, CDEDBT, CDPID, CDUSER, CDJOBN, CDCRTJ, CDCRTM, CDRNAME, CDURAB ) VALUES ('CRE', 701851, 'W3', 'A', '101-001101-01', '147120002', 373616, 374688, 'B08', 'Email Request', 'Projector - PROJECTOR CONFIGURATION ISSUE', 'Walter... -
I installed VS.NET 2005 on my windowsXp mechine successfully but when i try to installed MICROSOFT SQL SERVER 2005, setup windows saying
"SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL... -
lol.
I just saw that too!
I was just about to post to disregard that.
my bad.... -
'Failed to enable constraints' Error on TableAdapter.Fill
Hey all,
I'm getting this error only when I have two similar entries in an login_audit table where the only difference is the actionhost and date. The query works fine in sqlserver. just not in the dataset.
What can I do to solve this problem?
The table structure is:
...Code:userID(Guid) username (nvarchar(50)) firstname (nvarchar(50)) lastname(nvarchar(50)) email(nvarchar(MAX))
-
So I created the following view to get a total sum of all the hours and the projectconfigid .
SELECT ProjectConfigID , SUM(Hours) AS TotalHours
FROM Production.Time Log
GROUP BY ProjectConfigID
then I rewrote the procedure like this...
SELECT CONVERT(numeric (8,2),(CONVERT( float,th.TotalH ours)/CONVERT(float,p c.EstimatedHour s))) AS Progress
FROM vwTotalHours th INNER JOIN ProjectConfig...Leave a comment:
-
i tried that and I still get progress = 0 for some reason
for projectconfigid = 1
if the timelog.hours records have 5, 12 and 10, and the projectconfig.e stimatedhours is 36, the progress value should read .75Leave a comment:
-
How do I calculate something using values from two tables?
SELECT (SUM(Hours)/EstimatedHours) AS Progress
FROM Production.Time Log, Config.ProjectC onfig
WHERE Production.Time Log.ProjectConf igID = 1
I'm trying to calculate the progress of a task by adding all the hours from the timelog records and dividing it by the estimated time stored in the config table?
I wrote the procedure above but I keep getting the following error:
'Column 'Config.Project Config.Estimate dHours'... -
Need to check if user exists for file permission changes
Hey everyone,
I am trying to figure out to do a security check to see if a user account exists in order to change read/write/execute permissions for files and folders.
Right now I just have a textbox that accepts a username, but if that user doesn't exist, when the program runs it fails because there is no mapping to user accounts.
Does anyone know how to check that a user exists? -
Renamed a user control, now I get a missing assembly or directive reference
I renamed a user control from NativeColourCor rected to NativeColour, and rewrote the inherits part on the page code to match the name, but now i get this error:
'The type or namespace name 'NativeColourCo rrected' could not be found (are you missing a using directive or an assembly reference?)'
There must be somewhere else I am supposed to make the change as well but I have no clue where.
Can someone help me?... -
well that's the thing I can do it with c# behind my asp page. but it will only copy the text on postback.
basically:
Label1.Text = Text1.Text;
but as the user types it.
Is there a way javascript can kind of merge the two controls so that if one thing is entered into the textbox, it is also entered into the label?...Leave a comment:
-
dynamically add text to label as user inputs to textbox
Hey all,
I'm fairly new to javascript and i need to write some code into my webpage that will automatically post text from a textbox as user types it, into a label. Could someone please help me? Thanks.
Aaron -
yeah, i understand that's what I have to do. I just don't know if this function will work:
[CODE="asp"]
function IsSelected()
{
if ((cboParameters .SelectedItem.T ext == "All Passed Tests") || (cboParameters. SelectedItem.Te xt == "All Failed Tests")
|| (cboParameters. SelectedItem.Te xt == "All Incomplete Tests") || (cboParameters. SelectedItem.Te xt == "All...Leave a comment:
-
Dynamically enable/disable controls on dropdown selectedindex change
Hey all,
I'm trying to disable a couple controls if a user clicks on a certain item in a dropdown list. I can do it on postback, but if someone could help me to do it dynamically, that would be key! Thanks in advance!
Aaron -
wow. that didn't line up like I wrote it out before submitting. Well I hope you understand what I mean.Leave a comment:
-
How to add tab delimited items to a listbox
Hello all,
I am working with c# and am wondering if there is any way to add tab delimited items to a listbox in order for each line to line up.
I am trying to use the \t's to separate each value but they only add a couple spaces. basically I want to separate 4 values into columns for each line I add to the list box so it looks roughly like this.
DateTime | Test Name | Test Status |... -
How to Dynamically Load User Controls
I have a couple placeholders in which I want to dynamically load user controls into a multi-pageview based on db data.
The database returns the filename of the user control (i.e. UserControl.asc x), and a value (tdr.Page) to determine which placeholder it should load into.
I then use Server.MapPath to get the path to the user control but when it comes down to Load the control I keep getting the error "filepath\userc ontrol.ascx... -
you could read the file to a string and try using the split method.
string filestring = File.ReadAllTex t(filepath);
string[] word = filestring.Spli t(' ');
int wordcount = word.Length;Leave a comment:
-
Thanks for your help Jared, but I ended up solving the issue when I changed the sql statement to this (with the apostrophes):
[CODE="c"]
string sqlcom = "INSERT INTO Config.TestBoot h (TestBoothID,Te stBoothName,Con fig) " + "VALUES (" + testBoothID.ToS tring() + ", '" + testBoothName.T oString() + "', '" + tempXML + "')";
[/CODE]...Leave a comment:
-
figured it out.
i just had to put apostrophes before and after the tempXML in the insert statement.Leave a comment:
-
if i type sqlcom in the Immediate Window it reads:...Code:""INSERT INTO Config.TestBooth (TestBoothID,TestBoothName,Config) VALUES (1, .326, <?xml version=\"1.0\" encoding=\"utf-8\"?><Config><Testbooth> <TestBoothID>1</TestBoothID><Vertical>0.340999990701675</Vertical> <Horizontal>5777</Horizontal><Diagonal>193</Diagonal> <AreaIN>0.32600000500679</AreaIN><AreaFT>0.340999990701675</AreaFT>
Leave a comment:
No activity results to display
Leave a comment: