Hello, I'm normally the Java programmer here, but we got some old stuff running Pro*C.....anyway this is my error:
myprops.c: In function `my_setupPropertyCursor':
myprops.c:10931: error: called object is not a function
Here's the code:
/*================================================================
Name: mylibprops.c
Compile myprops to include this code.
10/29/04 -- MG -- Convert to use the search summary table.
=================================================================== */
#include <stdlib.h>
#include <math.h>
#include <homesland.h>
#include <htmllib.h>
#include <util.h>
#include <strutil.h>
#include <sqlca.h>
#include <oralib.h>
#include <datalib.h>
#include "props.h"
void my_setupPropertyCursor(const char * userId) {
int startmeup = 0;
int endmeup = 0;
char *escapedUserId = NULL;
/*Take care of a reduced result set for speed.*/
startmeup = 0;
endmeup = BARE_LISTINGS_PER_PAGE;
if (wf_filled("pageclicked")) {
endmeup = BARE_LISTINGS_PER_PAGE * atoi(wf("pageclicked"));
startmeup = endmeup - BARE_LISTINGS_PER_PAGE;
}
Olen(sql_stmt) = Olen(sql_count_stmt) = 0;
Ostr(sql_stmt)[0] = Ostr(sql_count_stmt)[0] = '\0';
escapedUserId = escapeSQL(userId); /** Remember to free this when we're done! */
/** if (!escapedUserId) escapedUserId = userId; We should probably bail, but we'll try to soldier on... */
/* printf("<!--- 31 mylibprops Hope this works --->"); */
snprintf(Ostr(sql_stmt), sizeof(sql_stmt.arr),
"SELECT b.state_code,\n"
" INITCAP(b.city) city,\n"
" b.listing_id,\n"
" b.street_number||DECODE(b.street_number, NULL, '', ' ')||b.street_name,\n"
" LTRIM(TO_CHAR(DECODE(b.list_price,0,NULL,b.list_price),'L99G999G999')),\n"
" b.list_price PRICE,\n"
" b.bedrooms,\n"
" b.square_feet,\n"
" b.full_baths,\n"
" b.half_baths,\n"
" b.three_quarter_baths,\n"
" NVL(b.year_built, 0),\n"
" b.lot_size,\n"
" 0 lot_size_units,\n"
" b.floors,\n"
" b.listing_arch_style_code,\n"
" INITCAP(RTRIM(b.listing_arch_style_desc)) otherstyle,\n"
" b.property_type_code,\n"
" '',\n"
" nvl(b.sold,' '),\n"
" INITCAP(RTRIM(b.listing_arch_style_desc)),\n"
" b.caption_summary,\n"
" (b.list_price * -1),\n"
" DECODE(b.pp, NULL, 0, 1) pplisting,\n"
" DECODE(b.oem,NULL,0,'HCPP',0,'BHG',0,1) ppoem,\n"
" NVL(b.actual_city, b.city),\n"
" NVL(b.actual_state_code, b.state_code),\n"
" 'N',\n"
" NVL(b.VIRTUAL_TOUR,'N'),\n" /*change the following line back to TNNEXTID2URL */
" DECODE(b.thumbnail_image_ref, NULL, b.ext_thumbnail_url, FORMATTING.TEMPTNEXTID2URL(b.thumbnail_image_ref)),\n"
" b.MLS_NUMBER,\n"
" 0,\n"
" b.attribution_logo_image_name,\n"
" b.attribution_logo_alt_text,\n"
" '' ppsearchcity,\n"
" DECODE(b.sold, NULL, 1, ' ', 1, 'R', 1, 'P', 2, 'U', 3, 'Y', 4, 'E', 5, 6) ppsearchsold,\n"
" b.data_owner_contact_id,\n"
" (b.office_contact_id - 10000000) office_contact_id,\n"
" (b.primary_agent_contact_id - 20000000) primary_agent_contact_id\n"
" b.NOTES,\n"
" nvl(b.LISTING_ID, 0)\n"
"FROM (SELECT a.*, rownum rnum"
"FROM(SELECT srch.state_code,\n"
" srch.city,\n"
" srch.listing_id,\n"
" srch.street_number,\n"
" srch.street_name,\n"
" srch.list_price,\n"
" srch.list_price PRICE,\n"
" srch.bedrooms,\n"
" srch.square_feet,\n"
" srch.full_baths,\n"
" srch.half_baths,\n"
" srch.three_quarter_baths,\n"
" srch.year_built,\n"
" srch.lot_size,\n"
" 0 lot_size_units,\n"
" srch.floors,\n"
" srch.listing_arch_style_code,\n"
" srch.listing_arch_style_desc,\n"
" srch.property_type_code,\n"
" '',\n"
" srch.sold,\n"
" srch.listing_arch_style_desc)),\n"
" srch.caption_summary,\n"
" srch.pp,\n"
" srch.oem,\n"
" srch.actual_city,\n"
" srch.actual_state_code,\n"
" 'N',\n"
" srch.VIRTUAL_TOUR,\n" /*change the following line back to TNNEXTID2URL */
" srch.thumbnail_image_ref,\n"
" srch.ext_thumbnail_url,\n"
" srch.MLS_NUMBER,\n"
" 0,\n"
" srch.attribution_logo_image_name,\n"
" srch.attribution_logo_alt_text,\n"
" '' ppsearchcity,\n"
" srch.sold,\n"
" srch.data_owner_contact_id,\n"
" (srch.office_contact_id,\n"
" (srch.primary_agent_contact_id,\n"
" %s\n"
" %s,\n"
" M.NOTES,\n"
" M.LISTING_ID,\n"
" FROM listing_search srch, OLS_MY_SAVED_LISTINGS M\n"
" WHERE srch.listing_id = M.LISTING_ID\n"
" AND M.FK_USERNAME = '%s'\n"
" ORDER BY M.DATE_SAVED DESC) a \n",
"WHERE rownum <= %d) b \n"
"WHERE rnum > %d \n"
(is_mls_recip) ? ", (srch.office_contact_id - 10000000) office_contact_id, srch.supplier_lr_logo, (srch.primary_agent_contact_id - 20000000) primary_agent_contact_id " : "",
wf("subdivision")[0] ? ", srch.subdivision" : (wf("street")[0] ? ", srch.street_name" : ", ''"),
escapedUserId ? escapedUserId : userId,endmeup,startmeup);
snprintf(Ostr(sql_count_stmt),sizeof(sql_count_stmt.arr),"SELECT count(*) , NVL(sum(vt),0) FROM (SELECT srch.listing_id, DECODE(srch.virtual_tour,'Y',1,0) vt "
" FROM listing_search srch, OLS_MY_SAVED_LISTINGS M\n"
" WHERE srch.listing_id = M.LISTING_ID\n"
" AND M.FK_USERNAME = '%s')\n",
escapedUserId ? escapedUserId : userId);
if(wf_exists("pageclicked"))
pageClicked = atoi(wf("pageclicked"));
else
{
/*
Oh boy, how to explain. Myprops uses displaylistings. If there are more
than 10 listings, displaylistings will crash if there is no query string.
Rather than try to fix displaylistings, it's easier and safer to
make a query string.
*/
fieldlist * newFieldListItem = (fieldlist*) (calloc(1, sizeof(fieldlist)));
newFieldListItem->name = (char *)_strdup("pageclicked");
newFieldListItem->value = (char *)_strdup("1");
newFieldListItem->type = '\0';
newFieldListItem->next = fields;
fields = newFieldListItem;
if (getenv("QUERY_STRING") == 0)
_putenv("QUERY_STRING=pageclicked=1");
pageClicked = 1;
}
Olen(sql_stmt) = strlen(Ostr(sql_stmt));
Olen(sql_count_stmt) = strlen(Ostr(sql_count_stmt));
printf("<!--- count stmt /n%s/n/n --->",Ostr(sql_count_stmt));
printf("<!--- sql stmt /n%s/n/n --->",Ostr(sql_stmt));
EXEC SQL WHENEVER SQLERROR DO sql_error();
EXEC SQL PREPARE S FROM :sql_stmt;
EXEC SQL PREPARE SC FROM :sql_count_stmt;
#ifdef USE_SCROLL_CURSOR
EXEC SQL DECLARE C SCROLL CURSOR FOR S;
#else
EXEC SQL DECLARE C CURSOR FOR S;
#endif
EXEC SQL DECLARE N CURSOR FOR SC;
if (escapedUserId) free(escapedUserId);
return;
}
