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 TouchToneTommy 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: *

  • Users: BDC2
  • Order by date
  1. BDC2

    Change a variable based on form submission

    The variable var1 defined in vars.asp is a local variable to vars.asp. If you are trying to change var1 in vars.asp so that it can then be used by other pages, this is not possible. If this is indeed what you you are trying to do then you need to store your variable in a way that every page...
  2. BDC2

    copyfile some times works!

    My advice would be to upload the files into a directory within your web site as defined by Server.MapPath rather than hard code a directory. This keeps your files in one place and allows you to port your code to another server more easily. In you code you have this line : response.write fo &...
  3. BDC2

    Using lon user info for session variable

    You would need to create and manage a separate (to NT) list of usernames and categories within a table in a database. Create a database table (T_UserCategories) with columns "Username" and "Category" and populate it with the NT usernames and their category. Retrieve the NT Username as per your...
  4. BDC2

    Click through to parent application functionality

    I am assessing SSRS as a tool to integrate with my application but I have no SSRS experience. I have a winforms VB.NET application written in VS 2005. I currently use devexpress grids to display tabulated data which allows me to click the grid and perform an action in my applciation (e.g. open...
  5. BDC2

    multiple rows as comma separated list

    Hi, I have 3 tables: T_Template containing a list of templates T_Field containing a list of fields T_Template_Fields containing a list of many field IDs against the Template ID If I try this: select FieldID from T_Template_Fields where templateid = 1 I get 5 rows returned containing 5 Field...
  6. BDC2

    web site on additional IP not running

    not sure if this has something to do with my second IP address or if I need to change my set up in IIS. My primary IP is 217.199.175.215 which resolves fine and my web sites work. It's the additional IP I'm having trouble with. Any ideas? BDC.
  7. BDC2

    web site on additional IP not running

    I have a dedicated server which had to be rebuilt. It was running several web sites one of which had it's own IP address since it is an ecommerce site with SSL for the checkout. I have tried to set this back up in IIS6 but when I try to view the web site it's not showing through http or through...
  8. BDC2

    Integrate HSBC E-commerce API with XML

    I didn't realise I could emulate POST using: xmlHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP") xmlHTTP.open "POST", "https://www.uat.apixml.netq.hsbc.com", False xmlHTTP.send xmlDoc then get the response back using: xmlDoc.async = False If xmlDoc.loadXML(xmlHTTP.responseText) Then Set...
  9. BDC2

    problems with sql query and searching access db like

    Access uses different wildcards to SQL, so in Access you query should be: select * from table where field like "*substring*" BDC.
  10. BDC2

    Integrate HSBC E-commerce API with XML

    I'm trying to integrate HSBC Bank's e-payment API solution into a re-developed site but I'm not getting any help from them and their documentation is awful, can anyone help? Customer enters their credit card details on my site using a form. I put the order information (not credit card info)...
  11. BDC2

    Display records

    Is you database in 'C:\Accounts\mysite\wwwRoot\northwind.mdb'? Your error suggests that your asp file is in a folder called samples but I thought that your database and ASP files were in the same folder? Can you tell us your file structure and exactly where your database and ASP files exist...
  12. BDC2

    Update disconnected recordset and save as XML

    Could you use the MSXML parser instead of the filesystem? 4Guys has a good article: http://www.4guysfromrolla.com/webtech/041404-1.shtml BDC.
  13. BDC2

    Display records

    If you are using IE, go to tools | Internet Options... Click the Advanced Tab and UNCHECK "Show friendly HTTP error messages". This should give you a more comprehensive error message rather than "page cannot be displayed" BDC.
  14. BDC2

    cart with text file as a database

    A shopping cart is one element of a e-commerce system which is too complex to rely on text files. I don't know of any products on the market that don't use a database. BDC.
  15. BDC2

    sql query on a windows web server not working but works locally...

    The obvious thing that springs to mind is that your web server date and time settings are different to to your local machine. dd/mm/yyyy on one and mm/dd/yyyy on the other. Have you tried outputing todays date on your web server using ASP to see if your hard coded SQL matches the format? BDC.
  16. BDC2

    dynamicly adjusted

    I would say: For Each thing In Request.Form Response.Write "str" & thing & " = " & Trim(Request.form(thing)) & "<BR>" strSql = "UPDATE NotValidatedMessage SET Message = '" & Replace(request.form(thing),"'","''") & "' WHERE ProfessionID = (Select ID from Profession where name = '" & thing &...
  17. BDC2

    dynamicly adjusted

    I read the question differently maybe, you're probably right though. I posted before I saw your reply. Well I think onressy has a lot of food for thought, maybe he can claify. BDC.
  18. BDC2

    dynamicly adjusted

    Yes, thanks tsuji, this came straight out of my head and is untested. You could always add a letter before the number and strip it out when processing BDC.
  19. BDC2

    dynamicly adjusted

    I think that the reason your sub routine isn't dynamic at the moment is because the ProfessionID is hard coded. You need to either pass the professionID along with the form element OR you need to look up the professionID for every form element when you update the database OR you need to use the...
  20. BDC2

    Advancing a For Statement inisde a IF Statment

    ...Or maybe this? For i = 0 to 100 For j = 0 to 5 If i+j > 0 then Response.write (j) Response.write (i) End If Next Next BDC.

Part and Inventory Search

Back
Top