473,503 Members | 1,700 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Frontpage Database result wizard and currency format in the result page ASP

4 New Member
Hi,
I have an Advantage Database and try to get the following code to work as a simple asp page:
Expand|Select|Wrap|Line Numbers
  1. SELECT
  2. f140.customer As CustomerNumber,
  3. f75.description AS CustomerName,
  4. f75.description2 AS Details,
  5. f42.description AS Branch,
  6. f140.masterpolicy as Masterpolicy,
  7. f140.policy as Reciept,
  8. f103.description AS Insurer, 
  9. f145.description AS Category,
  10. f140.characteristic AS Characteristic,
  11. f140.issuedate,  
  12. f140.effectivedate,
  13. f140.expdate,
  14. f140.canceldate,
  15. f140.grosspremium as Premium
  16.  
  17.  
  18. FROM  
  19. fpotype f145, 
  20. fcustomr f75, 
  21. finscomp f103, 
  22. fbranch f42, 
  23. fpolicy f140
  24.  
  25. WHERE  
  26. f145.code=f140.category 
  27. AND 
  28. f75.code=f140.customer 
  29. AND 
  30. f103.code=f140.insco 
  31. AND 
  32. f42.branchcode=f140.branch
  33. and
  34. f140.agent=788
  35.  
  36. order by customername
  37. ..
The result works fine, just I get nuts with the field

f140.grosspremium as Premium

It comes up as without formating as currency, any suggestions??
Advantage Database 7.1.0.10
Frontpage 2003

Thank you in advance

Anthony
Nov 30 '06 #1
0 940

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2967
by: J P Singh | last post by:
Hi Guys I am trying to store the currency symbol used for a trasaction in a database field but rather than store £ it stores £ (see the wierd character at the beginning of the symbol) instead....
2
3726
by: googley | last post by:
I'm starting a new thread for a problem that I ran into.. I'm trying to use STYLE SHEETS/CSS to update multiple table widths across many pages. I did get it working with one small problem that...
4
2923
by: tina.boroff | last post by:
I have just created a form for a Maintenance Database that has alot of VB code involved. Now they want the form on our Intranet instead. Is there a way that anyone knows to publish the form...
2
4827
by: Alberto | last post by:
I have a decimal field in a SQL Server DataBase who stores money and I want to show it in a TextBox and in a ListView controls in C#. If I do: txtMoney.Text = Convert.ToSingle(dr); I see...
2
1352
by: SStory | last post by:
My client wants to design ever changing forms in Frontpage and have them mailed in HTML format to her. How could I go about using ASP or ASP.NET to take the information of any form she designed...
3
2605
by: Jensen bredal | last post by:
Hello gurus, How do i handle Currencies from "asp.net form field " to "insert " querry in database? The "money" is entered in a textbox and my code is falling to the stored procedure due to...
1
406
by: tbearcuddles92543 | last post by:
Hi. I'm creating a business advertising directory website for all 50 states using FrontPage and Access. I am really not understanding how to mesh the two together. Some entries in the directory...
0
770
by: npahaladh | last post by:
Firstly, hi and I'm brand new to this stuff! I've got an Access database which I've moved across to SQL Server05(Upsizing Wizard). My problem now is linking this database(consisting of 12 tables)...
14
3069
by: boliches | last post by:
Help please. I have looked everywhere for the answer. I have a form (created in MS Frontpage 2000) FinanceApp.asp which should send the data to an Access 2000 database when the "Submit" button...
0
7203
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7281
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7334
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7462
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5579
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5014
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3168
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3156
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
737
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.