Hi,
im trying to report on 2 tables like the following
tblMain
MainId Name
1 a
2 b
3 c
tblSub
Id MainID Status
1 1 1
2 1 1
3 2 1
3 2 2
basically i want to show all the rows from the main table...
Hi,
I am trying to use a SiteMapPath item in my page which works fine for most of my pages.
However a number of URLs in the web.sitemap incorporate URL rewriting i.e. '/Products/ID=5/ipod.html' and the SiteMapPath wont seem to resolve it and display the correct node.
Is there any way i can...
Hi,
What do people think of using the literal control instead of a label control?
Im thinking of just using the literal control as i've had a lot of grief from a customer regarding SEO and the amount of redundant HTML code that is produced in ASP.Net.
With the label control you might...
Hi,
Is there anyway i can clear what is returned from a stored procedure?
Basically i only want to only return 1 table from the example below, instead of 1 empty table then a table of results.
select * from Product where name = 'test'
if @@RowCount = 0
begin
-- I would want to 'clear'...
Hi,
I am trying to add NT authentication to a sub folder of my site but am struggling to do so.
Is it possible to achieve this without making any IIS changes, the reason I ask is because when publishing a site, all sub-folders are deleted and therefore the IIS settings are lost.
I thought I...
Hi,
How do i create a virtual directory in asp.Net 2.0?
Im doing this so i can add an image folder to a project which isnt published to the live server.
Thanks,
Rich.
Hi,
Does anybody know if there is a free-hand measure tool?
Ive got a map and i wanted to trace my route and then work out the distance to scale.
Thanks,
Rich.
Hi,
I have a datatable which i need to order numerically.
However, even though the column contains numeric data, it is a string datatype.
Can i use a convert() in the order parameter? Ive tried the below code but it didnt work.
drChildMenus = dtMenus.Select("Menu = 1"...
Hi,
I'm trying to convert a number to its hex value which i can do with-
System.Convert.ToInt32(12323)
However, the number im trying to convert is much bigger (a MD5 hash result - 975415459309518814222848482335161230234) and the function errors.
Any ideas anyone.
Rich.
Hi,
On a friends computer i recently installed office XP.
On the next reboot the processor speed is shown at the top of the screen and at the bottom it shows Press DEL to enter setup and it just hangs there.
Pressing DEL does not do anything and none of the 'lock' lights work. I tried...
Hi ,
Is there anyway i can turn off the validateRequest at runtime?
I want to allow only administrators to be able to submit HTML in a form.
Thanks,
Rich
Hi,
I could'nt find a regex forum so being as im using VB at the moment, ill post here.
Im trying to test if a string contains 2 consecutive pairs e.g.
323535577091 true (5577)
312339565444 false
The closest i've got is (\d)\1(\d)\1
but this only matches if the 2 pairs are the same -...
Hi,
In my stored procedure i pass in a CSV list of IDs and use the IN statement to select from them.
However, sometimes i will pass in a blank string and therefore dont want to use the IN clause.
The below logic works correctly when the CSV list is blank -
where ((CategoryID in...
Hi,
The Scenario:
I am building a product database, each product belongs to a category. Each category will (usually) belong to a parent category. I need a query which can return each category and the number of items in it
e.g.
Computing(320)
Laptops(100)
PCs(100)
Printers(120)...
Hi,
Can someone explain what exactly the following url is doing.
Ive not seen this syntax before and am unsure of it.
http://www.test.com/index.asp/page=test2/test3.htm
Thanks,
Rich
Hi,
I need a function to check for an array of form elements.
At the moment I am using this -
if (document.form1.text_box.length == undefined)
//not array
But i need a way to do this in IE 5.01 and it doesnt seem to work.
Anyone have a different way of checking for this?
Thanks,
Rich
Hi,
Does anyone know of a keyboard shortcut to put the cursor into the 'find' box on the toolbar.
I know Ctrl-f opens the find window but most of the time im searching the current file so i dont need any of the other options that are in the find window.
Thanks,
Rich
Hi,
Ok, Im not a PHP programmer, can you use Com+ dll written in VB for use in ASP, in PHP? If so, whats the best way to handle collections?
Thanks,
Richard.
Hi,
Im using a recordset thats a join on 2 tables each with the same column name in them (not the foreign/primary keys).
Is there any way when im referencing the recordset that I can specify which one to return?
At the moment when I ask for rs("status") i just get the first one that is asked...
Hi,
Im making an MP3 jukebox from my old PC (AMD 300mhz), when i playback MP3s they slur when the PC is doing other things, even when i move the mouse!
The sound card is onboard the the motherboard, is this why it has such poor performance or is it just the spec of the PC.
Also, it is running...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.