Search results for query: *

Hi, I'm a bit useless at using excel and was wondering if anyone can help me create an insert script for my database? At the moment on my worksheet I have the following: productname prodid rc spy fitness other testa 1 1 testb 2 1...

Hi, I've been asked to provide a CSV with a whole load of products, their prices and descriptions from our db. After I've exported it using server.createobject ("scripting.filesystemobject") and try and open in excel the data is all over the place. I am assuming this is because of line...

hi, i am using the following formula to make an sql update statement in excel: ="update tablename set weight = '"&B2&"',name='"&C2&"',other='"&D2&"' where pk = "&A2 how do i add a comma (;) at the end? It errors if i try. Thanks Chris

Hi, I want to display images in rows of 3. The image name comes from the database and I am going through the recordset and outputting each image. i.e x x x x x x x x x How do I do this? All I can do at the moment is have them like: x x x Can anyone help on this issue? Thanks

Hi, Does anyone have any experience of using and scanning bar codes to update their SQL Server database. I have just got an ASP barcode generator component working and I'm now at the next step of seeing how to let people scan these barcodes (once printed) to update the db. Any friendly...

Hi, I am having trouble comparing 2 numbers: I have Minspend: 60 and ProductTotal: 339.2 <% if minspend < producttotal then %> do stuff <% end if %> This doesn't do anything. However if I change the ProductTotal to anything above 600 then it does work. So it is only looking at the first...

Hi, Is it possible to have a button on a page that will print RTFs I've created in a folder? Hoep you can help and thanks in advance. Chris

hi, I am currently getting data from my db and creating rtfs with it. how though do i format layout? I need to create a table with one row and two columns in the rtf - all of the "iewkind4\uc1\pard\b\f0\fs28" style stuff is confusing me no end. Does anyone know the syntax to create a table...

Hi, I am going to need to offer alternate index pages for each user that visits the site. So, I would have index1.asp and index2.asp User 1 gets index1, user2 gets index2, user 3 gets index1, user 4 gets index2 and so on. Does anyone have any ideas how to do this? (The reason for this is...

Hi, have some code in a vbs file that should drag all records out of a db and then spit them out into a csv file. I run the file and no errors are thrown up but no csv file is made. Any ideas - code below.... I have checked the permissions on the folder. Any help appreciated. Chris on...

Hi I need to create a CSV. At the moment, it works perfectly but the user has to submit the form. How do I get it to create the CSV when the page is called. I am going to use a scheduled task eventually. This is what currently works: <% on error resume next Set objConn =...

Hi, I have tried looking around but haven't really found anything. I am looking to get a price comparison system up and running on a shopping cart and wondered if anybody knew of any scripts or code available as a starting point... Thanks Chris Moore

Hi, I am trying to connect a laptop running XP Pro to an iMac running OS X. File sharing is enabled on my laptop. When I take the ethernet cable from my windows LAN (which works fine) and plug it into the back of the iMac I get a "media state.....media disconnected" message when I type...

Hi, Every time my page loads in IE6 the navigation reloads. How do I stop this happening? It works fine in FireFox. I do have <% response.expires = -1 %> at the top of my page. Would this affect the navigation graphics as well??? Can I force a users browser to cache the nav? Thanks Chris

Hi, Bit of an excel/VBA dunce so I'm hoping to enlist someone's help. I have a column of values, all numeric. I need to add a URL to the start of each value e.g: http://www.test.com/testproduct?testid=#value in cell in excel# Any ideas of how to do this? Thanks Chris

Hi, How do I put an else statement in?? I want to check if a field is blank, if it is then ask the user to fill it in. If it is filled in then ask them to check that it is correct... Thanks Chris Code Below: if (document.frm[i].value=='') { alert ('Please enter all personalisation...

Hi, I have two functions that need to run when I submit a form. One fucntion checks that all fields are filled out correctly (checkform) the other sets hidden fields to certain values (onsubmit) In the form tag if I put either of them in like this: onsubmit="onSubmit(this);" or...

Hi, I have a hidden field: <input type="hidden" name="xFirstName" value = ""> I also have a text field called FirstName. I want to set xFirstName to the value of FirstName if xFirstName is empty. Is it possible to do this? I tried this: function tester() { document.form.xFirstName =...

Hi, I have a Windows 2000 server running terminal services amongst other things. I need to install IIS so I've put the disk in and gone to Control Panel > Add Remove Programs > Add Windows Component etc... The list has other items greyed out and ticks on some and ticks not on others - all I...

Hi, If I install IIS on my Windows 2000 server will I have to restart it? I can't really afford to restart without making a lot of users more annoyed than they usually are you see. Many thanks Chris