Display Customer details in a new window

Results 1 to 7 of 7

Thread: Display Customer details in a new window

  1. #1
    Join Date
    Dec 1969
    Posts
    936

    Default Display Customer details in a new window

    Hello,<BR><BR>How can I click on a table cell and info relating to the person is displayed in a little window ?<BR><BR>so click on this :<BR><BR>&#060;TD BORDERCOLOR=#c0c0c0 nowrap&#062;&#060;FONT SIZE=2 FACE="Arial" COLOR=#000000&#062;&#060;%=Server.HTMLEncode(rs.Fi elds("TITLE").Value)%&#062;&nbsp&#060;%=Server.HTM LEncode(rs.Fields("FORENAME").Value)%&#062;&nbsp&# 060;%=Server.HTMLEncode(rs.Fields("SURNAME").Value )%&#062;<BR>&#060;/FONT&#062;&#060;/TD&#062;<BR><BR>then display a window with Customer Details (name, dob, address).

  2. #2
    Join Date
    Dec 1969
    Posts
    2,493

    Default RE: Display Customer details in a new window

    Just make it a link<BR><BR>&#060;TD BORDERCOLOR=#c0c0c0 nowrap&#062;&#060;FONT SIZE=2 FACE="Arial" COLOR=#000000&#062;&#060;a href="somepage.asp?id&#060;%=RS(FieldID")%&#062;" Target="blank"&#062;&#060;%=Server.HTMLEncode(rs.F ields("TITLE"))%&#062; &#060;%=Server.HTMLEncode(rs.Fields("FORENAME"))%& #062; &#060;%=Server.HTMLEncode(rs.Fields("SURNAME"))%&# 062;&#060;/a&#062; <BR>&#060;/FONT&#062;&#060;/TD&#062;<BR><BR>then on the next page just query the table for the recordid <BR><BR>Sql="select * from table where recordid=" & Request.querystring("id")<BR><BR>

  3. #3
    Join Date
    Dec 1969
    Posts
    936

    Default star

    cheers bud

  4. #4
    Join Date
    Dec 1969
    Posts
    936

    Default How can I set the window sizE ?

    Cheers for that, but I want to put it in a new window, so far I have :<BR><BR>Target="New_Window", but I would like to have the window quite small, is this possible ?


  5. #5
    Join Date
    Dec 1969
    Posts
    936

    Default Unterminated string constant

    When running a select query to view related deatails I get a Unterminated string constant ewrror?<BR><BR><BR>sql = "SELECT [Governor].[G_ID], [Governor].[TITLE], [Governor].[FORENAME], [Governor].[SURNAME], [GovernorPost].[appointed], [GovernorPost].[expiry], [GovernorPost].[status], [Post].[govtype], [School].[s_name], [School].[s_Address1], [School].[s_Address2], [School].[s_Address3], [School].[s_Address5] FROM School INNER JOIN ((Governor INNER JOIN GovernorPost ON [Governor].[G_ID]=[GovernorPost].[G_ID]) INNER JOIN Post ON [GovernorPost].[PostID]=[Post].[PostID]) ON [School].[s_ID]=[Post].[S_ID] WHERE [Governor].[G_ID]= "& Request.querystring("id")"<BR>

  6. #6
    Join Date
    Dec 1969
    Posts
    2,493

    Default RE: Display Customer details in a new window

    Use JavaScript<BR>&#060;html&#062;<BR>&#060;head&#062; <BR>&#060;Script Language="Javascript"&#062;<BR>function newwindow(w) <BR>{<BR> var jumpToHere;<BR> var winOptions;<BR> var popUpWindow;<BR> <BR> jumpToHere = w;<BR> winOptions = "top=200, left=200, width=115, height=150,scrollbars=yes";<BR> popUpWindow = open(jumpToHere, "MyWindow", winOptions);<BR> }<BR>&#060;/Script&#062;<BR>&#060;/head&#062;<BR>&#060;body&#062;<BR><BR>&#060;Table& #062;<BR>&#060;tr&#062;<BR>&#060;TD BORDERCOLOR=#c0c0c0 nowrap&#062;&#060;FONT SIZE=2 FACE="Arial" COLOR=#000000&#062;&#060;a href="javascript:newwindow(&#039;new.asp?id=&#060; %=RS(FieldID")%&#062;&#039;)&#062;"&#062;&#060;%=S erver.HTMLEncode(rs.Fields("TITLE"))%&#062; &#060;%=Server.HTMLEncode(rs.Fields("FORENAME"))%& #062; &#060;%=Server.HTMLEncode(rs.Fields("SURNAME"))%&# 062;&#060;/a&#062; <BR>&#060;/FONT&#062;&#060;/TD&#062;<BR>&#060;/tr&#062;<BR>&#060;/table&#062;<BR><BR><BR>&#060;/body&#062;<BR>&#060;/html&#062;<BR>

  7. #7
    Join Date
    Dec 1969
    Posts
    2,493

    Default RE: Unterminated string constant

    remove the " at the end<BR><BR>"& Request.querystring("id")"&#060;-- thats the problem <BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •