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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by eirikr

  1. eirikr

    web resource vulnerabilities

    The scan shows my web server is vulnerable with these below ones with no instructions on how to fix them web resource /admin/actions globally detected web resource /demo/index.jsp global detected ..... Does any one know how to fix those vulnerabilities? Thank you in advanced v/r Eirikr
  2. eirikr

    print a selected value from a drop list in asp.net

    Here is my main.aspx page <% Response.Write("status: " + ddl_1.SelectedIndex); %> <div> <asp:SqlDataSource ID="sds_1" runat="server" ConnectionString="<%$ConnectionStrings:... %>" ProviderName="<%$ ConnectionStrings:... %>" //-- ISSUE is here: if status=-1 i want to use this sql...
  3. eirikr

    print a selected value from a drop list in asp.net

    Yes, what i mean for debugging, so i can see what the value i get from selecting status, so i can set up sqlcommand like: if status==-1 (list all the resords) <asp: sqldatasource ... selectCmd = "select * from table where status is not null" else status=='Open' selectCmd = "select * from table...
  4. eirikr

    print a selected value from a drop list in asp.net

    In main.aspx page, i have a drop down list: <asp:DropDownList ID="ddl" runat="server" DataSourceID="filter_datasource" DataTextField="status" DataValueField="status" AppendDataBoundItems="True" AutoPostBack="True"...
  5. eirikr

    how to get the selected value from a dropdown list...

    In main.aspx page, i have a drop down list: <asp:DropDownList ID="ddl" runat="server" DataSourceID="filter_datasource" DataTextField="status" DataValueField="status" AppendDataBoundItems="True" AutoPostBack="True"...
  6. eirikr

    how to pass a username to updateCommand

    in webform.aspx has <body> <% String vdUser = Request.ServerVariables["AUTH_USER"]; %> ... <asp:SqlDataSource ID="dg_vendorTrk" runat="server" ConnectionString="<%$ ConnectionStrings:conn_vendor_server %>" ... UpdateCommand="UPDATE table1 SET vdLogAs=@vdUser WHERE...
  7. eirikr

    how to exec #include file

    <%@ Language=VBScript %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>Call file.asp from the database</title> </head> <body> call_inc_file.asp calls...
  8. eirikr

    how to exec #include file

    hello all i have a guest_link table with a column "contents" has value: <-- #include file="guest.inc" --> in my asp code, i pull that data out of database <%=contents%> and i expect it'll call that file.inc, but it does not. Instead it gives me a text string printed on the screen <-- #include...
  9. eirikr

    how to migrate ms excel db to mssql server 05

    I got it done, ty for help
  10. eirikr

    how to migrate ms excel db to mssql server 05

    I used Import/Export wizards in mssqlserver management studio to migrate data from excel sheet to sql server 05 I followed exactly what were shown in the book: -data src: ms excel with excel file path, then next with dest, i tried either: -dest: OLEBD for sql, or SQL native client with my...
  11. eirikr

    how to migrate ms excel db to mssql server 05

    i get an error message when i try to import an excel databse into a table in sqlserver 2005, the error something about connection to sql failed, no such host is known when i set ms sql native client. Please tell me why, and what should i do. Thanks
  12. eirikr

    how to migrate ms excel db to mssql server 05

    Thanks, it's what i need to know
  13. eirikr

    how to migrate ms excel db to mssql server 05

    how can i migrate a ms excel db sheet to a table in sql server 2005. Thank you for help.
  14. eirikr

    need help with tsql

    Having 4 tables System has columns: id, sysName PC has has columns: id, serialNum Mac has has columns: id, macAddr IP has has columns: id, ipAddr Example: System Serial Mac IP Sys1 Ser1 Mac1 IP1 Sys1 Ser1 Mac2 IP2 How can I make the output like Sys1 Ser1 “Mac1; Mac2” “IP1; IP2”...
  15. eirikr

    how to combine the sql results from diff sql statements

    with 3 diff tables: v_Collection tbl: CollectionID Name 1 walgreen 2 target 3 sears v_FullCollectionMembership: CollectionID ResourceID isClient 1 100 1 2 200 1 3 300 0 v_image: ResourceID imageVersion 100 123 200 null 300 null First sql: select T1.Name, T2.ResourceID, count(T2.ResourceID) as...

Part and Inventory Search

Back
Top