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!

Register Log in
  • Congratulations Chriss Miller 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: ranta
  • Order by date
  1. ranta

    Spaces appearing in HTMLBody when sent through email

    Chris, Thanks for the response. I am a little surprised that we haven't come across this issue before. Even looking at the email in question there are huge chunks of HTML content which span more than 76 characters and don't seem to be forced to break lines. Do you have any understanding as to...
  2. ranta

    Spaces appearing in HTMLBody when sent through email

    Hi, I am currently sending a HTML newsletter from an ASP application using the script below. I have used this in many applications with no issue however I am now facing a problem that when the HTML content (which I have validated by printing to the screen) is sent using the .send command a...
  3. ranta

    Post a form WITHOUT javascript

    I'm not displaying the processpayment page, its part of the background process as far as the user is concerned. To contact the payment provider I need to submit the required fields in a form with a HTTPS request. i.e; <form name="f1" method="post"...
  4. ranta

    Post a form WITHOUT javascript

    I am using ASP / HTML for the front end over an SQL2005 server. The user will see the details of their order in the checkout page, this will contain info like the billing and delivery address, product details etc. The user clicks the "Pay" button which submits a form with all the data to a...
  5. ranta

    Post a form WITHOUT javascript

    I am building a Bobby A accessible site complete with ecommerce which means I can not use any javascript on the site (or more accurately I need to ensure all functionality works without Javascript enabled). The problem I have is that within the ecommerce process I am calling a stored procedure...
  6. ranta

    SCOPE_IDENTITY() returning NULL - URGENT

    The SCOPE_IDENTITY() function is directly after the INSERT statement, let me give you cut down version of the code... Function copyRecord(recordID) SQL="INSERT INTO tableName (name,desc) SELECT name,desc FROM originalTable WHERE recordID="&recordID&"" set rs=objConn.execute(SQL) set...
  7. ranta

    SCOPE_IDENTITY() returning NULL - URGENT

    I have a function which is insterting a record into a table and then using SCOPE_IDENTITY() to return the newly created ID for that table. This all works fine untill I call the function within a loop, then the SCOPE_IDENTITY() returns a NULL. Does anyone have any idea why this is happening...
  8. ranta

    Building Tree from Child level up

    I have a database with a category table built using the child/parent relationship, the system users will have access to specific products related to these child categories. Once I have identified the products they have access to I want to build a navigation bar to only inlcude the category the...
  9. ranta

    Euro symbol in HTML Email

    Thanks for that, am still at a loss though... Do these need to be set as META tags or simply input exactly as you have entered betweeen the <head> and </head> tags?? Have tried seting up as META tags and seems to make absolutely no difference.. Cheers,
  10. ranta

    Euro symbol in HTML Email

    Hi, I have a dynamicaly generated HTML email which is being sent to our clients, part of the email displays current revenue generated by the client in their local currency. The currency symbols are populated from an SQL table. This works fine for all currency's including the Euro symbol when I...
  11. ranta

    Searching Documents on the server

    I have a directory of word documents on my server which have been uploaded from my website.. I need to be able run keyword searches over the documents, is there anyway I can do this? Thanks in advance!
  12. ranta

    Bulk Insert Problem - Possibly MDAC 2.8

    Hi, Hopefully someone can help me here, I have a stored procedure which is running a bulk insert statement to copy records from a CSV format file into an SQL server table. This has been working perfectly well until recently, the code has not changed but the operating system on the server has...
  13. ranta

    Cannot get ASP page to display

    Hi, Are you actually getting the page can not be displayed message? If so there seems to be a little &quot;quirk&quot; with explorer. Try copying out all your code into notepad or something and replace it with some random text, i.e. &quot;ss&quot;. Save this and refresh your page. You should...
  14. ranta

    Exporting to excel from ASP report

    I am currently using the ContentType = &quot;application/vnd.ms-excel&quot; to export a dynamicaly created report into excel. My question is, is there anyway to prompt the user as to whether they want to save the excel document or launch it. I have seen this before but am not sure if its down to...
  15. ranta

    if object exists

    I have already tried that; if exists (select * from dbo.sysobjects where id = object_id('GLOBAL_POS.DBO.NA_052003_BP') and OBJECTPROPERTY(id, N'IsUserTable') = 1) This still fails.. it works if I run it locally...
  16. ranta

    if object exists

    ...is in a different database to the SP, I have tried using the following code but this only works where the table and the SP are in the same database... if exists (select * from dbo.sysobjects where id = object_id('NA_052003_BP') and OBJECTPROPERTY(id, N'IsUserTable') = 1) Any ideas??? Thanks
  17. ranta

    Coverting input date...

    Ok, a Javascript simpleton requires help.... I have two form fields, startDate and endDate which are formatted as follows; startDate - 'December 03' endDate - 'March 04' I need to compare these fields within javascript to see how many months have been selected... All responses welcome, I...
  18. ranta

    Accessing three comma deliminated variables in order...

    OK, I think I see where you are coming from. I was originaly going to send the detail as three seperate variables, i.e. @code - '1,344,8877,3,144...' @date1 - '01/01/03,02/01/03,03/06/04...' @date2 - '10/02/03,02/04/03,25/07/03...' From what I can understand of your code you are saying that...
  19. ranta

    Accessing three comma deliminated variables in order...

    Forgive me ignorance but what exactly does this achieve? from what I can understand of your code this is simply going to split out each code within @IN.. There could be any number of codes within this variable so I would still really have to loop round and I still have the problem of matching...
  20. ranta

    Accessing three comma deliminated variables in order...

    I am passing three comma deliminated fields to my stored procedure, the first of which contains codes, the second two contain dates pertaining to the codes in the first. They are all in order, is there a quick way of matching up this data into a temp table so I get on record for each code...

Part and Inventory Search

Back
Top