Book Quest

[JoeWass]

Hiya guys another proud release o'mine... well release. It's a monster job, cataloguing an entire book shop.

This is two days' cataloguing.. http://www.book-quest.com/
I know the formatting of the currenty isn't exatctly great (anyone know how to use the format( function (at least I think that's what it's called) so I can turn 8.5 into 8.50 ?

And I will be writing a legend to things like dj, foxed, etc etc. It's second hand book lingo i'll have you know...

anyhow your please comments, sirs!

[Tim Marshall]

Try Format Number, should do what you need. Change the '2' to display the amount of numbers after the decimal point!!

<%="£" & FormatNumber(Session("price"),2)%>

Tim Marshall

[Tim Marshall]

The sites good, i'd think about removing the 'entire stock link' because it will slow your page down if it loads a lot of records.

Perhaps a top 20 of the month instead or the more rare books could be shown instead as you do have a thorough search section.

Nice Job!

Tim Marshall

[JoeWass]

Cheers! That's only one cabinet out of about 15...
Thanks for format code. I'd done it before in some dim and distant project but had clean forgoten... and how did you (nearly) guess the variable name I'd chosen?

Also the customer isn't ... hands on with computers. Certainly not enough to make a selection of the month! Full stock list was so client can do exactly that and for google. Hits and that. Why not take full advantage? And I don't believe in anything underhand like making it the same colour as background. Neither does google from its docs.

Point taken onboard however; I might consider a precompiled html one tho...

[JoeWass]

So how's this
http://www.book-quest.com/stocklist.htm
I like it when things work

[Tim Marshall]

Looks good, need to sort the tags at the bottom though!!!

Nice job!

Tim Marshall

[JoeWass]

ssh! you really think I revisited the horror of all that data again by scrolling down? Later. Friday night is not for tags.

[Tim Marshall]

This won't hurt too bad, your 'BODY' and 'HTML' tags just need a closing '>'

Tim Marshall

[markjanssen]

I remember .NET has some functions for currencies..it'll then add currency signs etc.

If anyone wants to I will search for the code.

[JoeWass]

I know re tags its just I had some barbecueing to do... re currency worry not. Thanks for offer, but 1) it's not .net and 2) solution found in formatnumber or numberformat or whatever it was (thanks whoever gave me that syntax).

If only there were import and translation functions for shop inventory > data ...

How big can I stretch this access file before it breaks? It looks like I'm looking at ... 5550 entries..? each no more than 3k. I'm _assuming_ that's acceptable, but MS never ceases to shock me. Answers on the back of a twenty pound note...

[markjanssen]

What'd you mean, 'before it breaks'?

btw, use html entities for non-alphanumeric characters (like the copyright sign, pound sign, euro sign). This ensures end-users will see the character and not another.
copyright sign: &copy;
pound sign: &pound;
euro sign: &euro;

[JoeWass]

re entities. you're right changed.
re 'before it breaks'. The number of people who tell me that Access can't take the strain (apparently Paul asked my friend's brother to move over to mysql or something for that reason) has started to frighten me, and I was wondering if anyone knew what that breaking point was.

[markjanssen]

It hasn't got to do with the number of records but more how you query the database..when you do lots of complex queries, access simply breaks easier (or does everything very slow). Of course with more records, queries also take more time.

We're developing a technology in .NET to reduce the number of database queries by 50% .

[JoeWass]

I see. I will have to look into getrows, as I'm not learning .net. It all looks so completely logical and oop i'm not too sure I like it

I had considered precaching searches by term like with stocklist.htm . Or maybe not. It's not exactly popular as popular...

[markjanssen]

Our system will work like that but a bit more intelligent...