Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. G00GLER

    sql procedure where i have a subquery in an insert statement

    good. have you had problems with it? I had one development issue and called their tech support and actually got a team member call me back twice to follow up.
  2. G00GLER

    sql procedure where i have a subquery in an insert statement

    bikerboy yes i tried that. Denis YOU ARE AWESOME definitely reading your blog now. Originally I defined @tblName as varchar but the whole return value of query was throwing me off. THIS WAS SO HELPFUL
  3. G00GLER

    sql procedure where i have a subquery in an insert statement

    SET @MaxId = SELECT MAX(id) FROM @tblName DOESN'T work , i need to return maxid of a tablename that is a parameter CREATE PROCEDURE dbo.sp_SubmitRequest2 ( @tblName, @Deadline varchar(50), @Requested varchar(50), @RequestedBy varchar(50), @RequestedFor varchar(50), @CAM...
  4. G00GLER

    how to call my web service if requires one parameter

    pretty sure it's simple answer but so many ajax articles and none of my searches have returned a solution. Trying to reference my .net web service that recieves a string and returns a string. i seem to be getting an error on this line whatsthematter.asmx/SayHello"); function call_server() {...
  5. G00GLER

    Defining Native Application in IIS?

    There is a way to do this using HTTP header: http://support.microsoft.com/kb/260519/EN-US/ but I don't understand the example given: Content-disposition: attachment; filename=fname.ext SUMMARY When you serve a document from a Web server, you might want to immediately prompt the user to save...
  6. G00GLER

    datagridview dynamically add imagecolumn and populate it

    if i have a datagridview that is populated with an xml file. I have images in a resource file that i'd like to show in the datagridview based on values in one of the column say light foreach (DataRow dr in myDataSet.Tables["tblXMLExport"].Rows) { switch (dr["Light"].ToString()) { case...
  7. G00GLER

    How do you only update changed records

    thanks for responding stevexf i will into your first suggestion there will be 50 xml files one each on 50 some desktops. i'll likely add a counter column to the DB Table just because more comofortable and have a tight deadline. but i am going to look into your checksum later it sounds like...
  8. G00GLER

    How do you only update changed records

    i understand if i am running an Application that loads in xml, i make changes and i call dataadapter to update the sql table. what i don't understand is if i have an app that is mostly offline. several times app is opened and closed only saving xml file to hard drive, on the rare occasion it's...
  9. G00GLER

    My First Web Service

    NEED TO RETURN a dataset: this is how I would do it going directly from a windows form to sql server: [CODE] private void RetrieveData() { //MYSQLSERVERCONNECTION DBConnStr = "Data Source=blah, blah, blah"; SqlConnection SQLCn = new SqlConnection(DBConnStr); //MY DATAADAPTER SqlDataAdapter...
  10. G00GLER

    how to REFACTOR this?

    Thank you both!
  11. G00GLER

    how to REFACTOR this?

    how do i define stoplight as an object? can you recommend a good book, or code snippet? thank you both
  12. G00GLER

    how to REFACTOR this?

    i should clarify GreenLight0 (all the lights) are images on a winform. I tried private void ClearLights(int i) { ("GreenLight"+i).Visible=false; ("YellowLight"+i).Visible=false; ("RedLight"+i).Visible=false; } But obviously there is something more to it.
  13. G00GLER

    how to REFACTOR this?

    basically i have 5 stoplights and when user changes the from red to green i clear all images of that stop light with the clearLights function but since I have 5 stoplights i created 5 ClearLights Functions, is there a way to just have one and pass the integer of through so I can change...
  14. G00GLER

    Make Links Links

    close funtion autolink: http://www.tees.ne.jp/~maruo/back/asp/sample.html only thing is it replaces src="http:// as well
  15. G00GLER

    Make Links Links

    scenario is I am reading an xml file and i need to show how one would display links as links, i should be able to do this in c# or using xslt and javascript: here is where i am having a problem with the javascript: \\Reading in Layer var strTemp = document.all["kyle"].innerHTML; var...
  16. G00GLER

    select items in listbox based on query

    Solution: For i = 0 To Me.ListLegalTheories.ListCount - 1 If DCount("[LegalTheoryID]", "Matrix", "[FactID] = " & DMax("[FACTID]", "FACTS") & " AND [LegalTheoryID]= " & Me.ListLegalTheories.ItemData(i)) > 0 Then Me.ListLegalTheories.Selected(i) = True End If Next i...
  17. G00GLER

    select items in listbox based on query

    basically I have a matrix, when a user enters in a fact, they catergorize it by legal theories. so when someone edit's this fact the listbox should select the items already associated with this item. If user makes changes by unselecting then update button would remove from the matrix all entries...
  18. G00GLER

    Regex and the period?

    any pointers? i got nothing googling this.
  19. G00GLER

    Regex and the period?

    Quick question, i want to replace the webaddress to reflect the new location in 118 sql text fields. so i am reading them in, doing regex.replace so I can do an update the text fields. The following works: messageReplaced = Regex.Replace(message, "intranet", "dcintranet"); However this desired...
  20. G00GLER

    migrating asp pages from IIS5 to IIS6

    Wasn't sure where to put his in ASP or IIS, but IIS didn't appear to be very active: here's the link to the post. http://tek-tips.com/viewthread.cfm?qid=1145947&page=1 TIA

Part and Inventory Search

Back
Top